I Need to get the weekly retention users. If user has made the transaction in week 4, that user is there in Week 0, week 1, week 2, week 3, week 4.
If User made transaction in week 0, and week 3 then user will be there in Week 0, week 1, week 2, week 3 Thanks @bbaird,
I am updating the question with precise information and question
Here is my table data
The Result I am looking for
Users count is kinda cumulative but unique users.
For example if user-1 has performed transaction 3 times in week-0, then count for week-0 is 1
If User-1 has performed 3 transactions in week-0, 2 transaction in week-2, 1 transaction in week-3, then count will be like this
week-0 -> 1 (i.e. he has performed transaction >= week 0)
week-1 -> 1 (i.e. he has performed transaction >= week 1)
week-2 -> 1 (i.e. he has performed transaction >= week 2)
week-3 -> 1 (i.e. he has performed transaction >= week 3)
There can be any number of weeks. It is not fixed to 4 weeks or 8 weeks.