Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to calculate the unique customer visit count by combining (Customer and Date)
Suppose if customer A visited a store on 1/1/2012 for 5 times it will be treated as 1 visit and if customer B visit the store on the same day (1/1/2012) then the total unique visit is 2.
In my calculation , Unique visit is calculating as 4 instead of 5. (1/1/2012,3/4/2012,5/3/2012,12/3/2012 (Customer A),12/3/2012 (Customer B).
So, totall unique visity should come as 5 instead of 4. How to calculate the same?
Thanks,
Selva
Hi,
Try this expression.
sum(aggr(Count(DISTINCT Date),Customer))
Regards,
Kaushik Solanki
Hi,
Use the expression : Count (DISTINCT Date & Customer)
Regards,
som
Hi,
Try this expression.
sum(aggr(Count(DISTINCT Date),Customer))
Regards,
Kaushik Solanki
Thanks Som/Kaushik,
Both of you solution worked...
Selva