7 Replies Latest reply: Oct 20, 2017 1:27 AM by Shamit Shah RSS

    Set analysis to find distict values

    Shamit Shah

      Hi,

       

      I have the following expression which gives me the total count of the number of clients over a fortnight period (current week + previous week):

       

      count(distinct{<[Shifts.CreatedStartDate] = {">=$(=Date(WeekStart(Today()),'DD/MM/YYYY'))"}>}[Client])

      +count(distinct{<[Shifts.FULLPRW]={1}> }[Client])

       

      Now I need to find the number of distinct clients over the fortnight. Any ideas on the expression?

       

      Thanks