Forum Discussion

hani1711's avatar
hani1711
Regular Visitor
1 year ago

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...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

max week is 47 and 004 is in week 44, why not count 004 for last 6 weeks?

hani1711's avatar
hani1711
Regular Visitor
1 year ago

because 004 isn't in week 47, the customer should be in the week 47 first before checking last 6 week

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    for the middle pivot table. if not in week 47, then even it exists in last 6 weeks, we don't want that. Why we need to check last 6 weeks?