Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Expression1: Count({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer)
Expression2: Count(DISTINCT Customers)
2
Count({<Date = {"<=$(=Date(Today(), 'YourDateFieldFormat'))"}>} distinct Customer)
or
Count({<Date = {"<=$(=Date(max(Date), 'YourDateFieldFormat'))"}>} distinct Customer)