4 Replies Latest reply: Nov 12, 2017 9:54 PM by Kenneth Holden RSS

    count blank weeks

    Kenneth Holden

      I am looking how rtf create an expression to count blank weeks for my sales rep.

       

      Currently it counts the weeks they wrote business and it divides by the same,, The issue is if they write business in 40 weeks then they have 12 bank weeks and the average should be smaller.

       

      how do I tell qilksense to count blank weeks?

       

      thanks.

       

      Count(distinct(PACKAGE_ID))/count(distinct(WEEK))