Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
7 years ago
Solved

Top 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.

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% EnrollmentCalls Handled
123%150
213%200
314%180
4100%1
514%150
60%0
70%4
811%124
919%145
1027%203
111%10
12100%2
130%0
14100%4
150%0
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

4 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    7 years ago

    dw700d

     

    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)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.