3 Replies Latest reply: Mar 26, 2013 1:57 AM by Selvakumar S RSS

    Unique Customer Visit by (Customer and Date Combination)

      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.

       

       

      Unique Visit.PNG

      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