Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Agent Id | % Enrollment | Calls Handled |
1 | 23% | 150 |
2 | 13% | 200 |
3 | 14% | 180 |
4 | 100% | 1 |
5 | 14% | 150 |
6 | 0% | 0 |
7 | 0% | 4 |
8 | 11% | 124 |
9 | 19% | 145 |
10 | 27% | 203 |
11 | 1% | 10 |
12 | 100% | 2 |
13 | 0% | 0 |
14 | 100% | 4 |
15 | 0% | 0 |
Solved! Go to Solution.
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
Thank you all for you the input.
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) RETURN TOPN(5,_table,Sheet20[%enrollment],DESC)
Proud to be a Super User!
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.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |