Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to count the frequency of visits of clients based on if they made a transaction on any day.
if ( (Count(distinct ( ([TRANSACTION]) )))>1,1, (Count(distinct ( ([TRANSACTION]) ))) )
I put that in a pivot table, it shows me what i want in the pivot table but the totals always =1
How can I fix it so that the totals show their sum of visits per day
if ( (Count(distinct ( ([TRANSACTION]) )))>1,1, (Count(distinct ( ([TRANSACTION]) ))) )
count({<TRANSACTION={"=count(distinct TRANSACTION)>1"} TRANSACTION)