Summarizing results of a measure

[jhartranft60]

Hello,

I have a table with multiple metrics for a call center (dumbed down example below).  I determine a quarterly rating based on their average productivity in each metric per day.  So, for example, a "Does Not Meets" rating would be an average of 19 outbound calls per day or less, a "Meets" rating would be between 20-25 per day, etc.  I already have measures that count the number of days worked, sums the number of calls and calculates the average.  I also have measures to calculate the rating =IF(Avg_Calls<20, "Does Not Meet", IF(Avg_Calls<26,"Meets","Exceeds"))).  All of that works perfectly, but now I want to go back and analyze these ratings.  I want to know how many agents received a "Does Not Meet", etc. and what % of the population received each, but I'm having trouble figuring out how to do so.  Any help would be appreciated!!

Name	Date	Outbound Calls	Inbound Calls
Bob	7/1/2019	23	8
Bob	7/2/2019	20	9
Jill	7/1/2019	22	10
Jill	7/2/2019	27	4

[jhartranft60 · Accepted solution]

I've come up with a different, more efficient solution by creating a new table via SUMMARIZE(), calculating the totals/averages and analyzing from there.  Thanks

[Anonymous]

I think you can accomplish what you're describing by using a calculated column for " =IF(Avg_Calls<20, "Does Not Meet", IF(Avg_Calls<26,"Meets","Exceeds")))" categorizing, and then calculating the count for each catagory in a visual.