Forum Discussion
Identify if value is above or below parameters
Hello,
I am trying to find the best way to show if a value is over or under a set criteria. I have a list of employees who each have a performance rating assigned to them. I'm trying to show whether the total % of each rating type is over or under what we have set as a good distribution.
In my example:
Rating 1 - Within guidance
Rating 2 - Under guidance
Rating 3 - Within guidance
Rating 4 - Over guidance
What would be the best way to go about this? I thought of using a traffic light indicator or something similar.
Thanks, Shannon
2 Replies
- amitchandak
Super User
srjohnson212 , Based on what I got
a new measure =
Divide(countrows(table), Calculate(countrows(Table), allselected()) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270sHello amitchandak, I already have the % employees. What I"m looking for is how to get the Under and Over distribution. For example, for Rating 2, the % employees is 45% which is outside (under) of the set range of 55-65%. I'm asking how to I calculate how much the % employees is under or over the set ranges shown in graph.
