Good day all,
I am using the top n filter to show me the top 5 agents by % enrollments. The results however are misleading because the agents that appear in the top 5 have only taken 1 or 2 calls.
I would like to show the top 5 agents by % enrollment but I want to excluded agents that haven’t handled at least 100 calls. Is this possible?
Go to Solution.
is %enrollment a measure? or an attribute?
If it's a measure you can set the visual level filter :
Call Handled (Filter Type advanced filtering): show items when the value is greater than or equal 100
Agent ID (Top N); Top 5 By %enrollment
View solution in original post
You could add calculated column [Is in Top]
Is In Top =
IF(Table1[% Enrollment] < 1
|| Table1[Calls Handled] > 2;
Aftert that you have to add an filter on [Is In Top] = 1 at your visual or page and apply TopN filter on [% Enrollment].
P.S.Here I add an addidittional condition on [Calls Handled] > 2, so if an employee handled more than 2 calls and have 100% enrollment, he will be considered in the rating.
I use DAX to create a new table to get your result. Plesae see if it works for you. Thanks.
Table 3 =
VAR _table = FILTER('Sheet20','Sheet20'[calls]>100)
Thank you all for you the input.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!