Unique Customer Visit by (Customer and Date Combination)

[#1]

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

[somenathroy]

Hi,

Use the expression : Count (DISTINCT Date & Customer)

Regards,

som

[kaushiknsolanki · Accepted solution]

Hi,

     Try this expression.

     sum(aggr(Count(DISTINCT Date),Customer))

Regards,

Kaushik Solanki

[#4]

Thanks Som/Kaushik,

Both of you solution worked...

Selva