Re : Accumulation of distinct customers till date

[#1]

Hi All,

i have a date wise data of customers who are active in each date.i need to make a table with the count of distinct customers who were active till tht date.

dimension would be Date.

Expression 1. Count of customers who are active on tht date

Expression 2 count of distinct customers who are active till that Date.

please suggest.

Regards,

Reena Abraham

[Anonymous]

Well,

Expression 1 could be: count({<Status={'Active'}>} distinct CustomerID)

For Expression 2: Pls share the sample data, need to see how data is being captured. As per my understanding I hope a customer who is active on 18 Sept, may not be active on 19th Sept...

Pls post some samle data.

[sunny_talwar]

Expression1: Count({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer)

Expression2: Count(DISTINCT Customers)

[maxgro]

2

Count({<Date = {"<=$(=Date(Today(), 'YourDateFieldFormat'))"}>} distinct Customer)

or

Count({<Date = {"<=$(=Date(max(Date), 'YourDateFieldFormat'))"}>} distinct Customer)