Forum Discussion

marial16's avatar
marial16
Icon for Helper II rankHelper II
3 years ago

dispaly visual with average evaluation score per year

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 ?

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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])) )