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

    Set analysis to find distict values

    Shamit Shah



      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?