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

# 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.

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

• ###### Re: Unique Customer Visit by (Customer and Date Combination)

Hi,

Use the expression : Count (DISTINCT Date & Customer)

Regards,

som

• ###### Re: Unique Customer Visit by (Customer and Date Combination)

Hi,

Try this expression.

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

Regards,

Kaushik Solanki

• ###### Re: Unique Customer Visit by (Customer and Date Combination)

Thanks Som/Kaushik,

Both of you solution worked...

Selva