dispaly visual with average evaluation score per year

[marial16]

Hallo,

i would like to create a graph that will display the following data from an evaluation app only for completed evaluations.

the number of employees by employee type that were evaluated above average score. (max 100%)

There is a secondary list for employees with a column called Position (lookup to Positions list)

the main list has all the evaluation data columns (uniqueId, employeeName, Score, Year, status)

i am not sure how and which would be the appropriate visual.

Any ideas ?

[amitchandak]

@marial16 , Based on what I got

AverageX(Values(Table[uniqueId]), calculate(Sum(Table[Score])) )

or

AverageX(Values(Table[Year]), calculate(Sum(Table[Score])) )

or

AverageX(Summarize(Table, Table[uniqueId], Table[Year]), calculate(Sum(Table[Score])) )