This content has been marked as final. Show 3 replies
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?