Forum Discussion
Distinct Count Based on Week Number Before Selected Week
Hello, I have table consist of CustomerID, TransactionDate, WeekofYear. I want to DISTINCTCOUNT the customer based on 6 weeks before current week and display it in column chart. So if the column ch...
could you pls provide some sample data and expected output?
hi ryan
here is the sample of data and what the expected value
Example:
1. For week 47 the value should be 3, because just the 3 customer in the last 6 week based on customer in week 47, cust 004 is excluded
2. For week 47 with the filter brand A the value should be 2, with the same reason
