1 Reply Latest reply: Mar 29, 2015 3:45 PM by Michael Solomovich RSS

    Counting a distinct clients by comparing current & prior

    Hamish Imrie

      Hi All,

       

      I am trying to client all of the clients in the current time period who ALSO had activity in a prior period.

       

      The set analysis to determine the correct client count for the current time period is:

      Count(Distinct  {<TransactionDate = {$(var_currentdates)}>}[Client Name])

       

      I now need to extend this formula to only include clients that ALSO had activity in the prior period

      TransactionDate = {$(var_priordates)

       

      Any help would be greatly appreciated