Forum Discussion
dw700d
Post Patron
Post PatronTop N with conditions
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...
Hi,
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
You could add calculated column [Is in Top]
Is In Top =
IF(Table1[% Enrollment] < 1
|| Table1[Calls Handled] > 2;
1;
0)
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.