11 Replies Latest reply: Mar 27, 2018 12:35 PM by Jesus Pita Merino RSS

    need a solution

    Kenneth Holden

      i am using the following expression

       

      =count(distinct(agenctlastname)/count(total distinct(agent last name)

       

      This gives me the % productivity of active reps.

       

      I am attempting to use this expression to figure out what the rep productivity was in a specific week. The problem it is uses the number total reps as of the current moment vs the number of sales reps previously.

       

      For example:

       

      week 1

      week 2

      week 3

       

      in week 1 say I had 25 reps

      in week 2 i had 27 reps

      in week 3 I had 30 reps,

       

      the expression is using 30 reps for all weeks. How do i write the expression so qliksense will only total the number of reps that were available in week 1 for example?