Hello, I have a dimension called activity_day which is just a column of daily dates from 2020-01-01 to 2021-12-31, etc. I also have a measure active_users that counts unique active users on that activity day (count_distinct).
How can I calculate unique users in the last 14 days for each activity day including that activity day? Preferably with another measure but a table calculation would also work. Something like this:
So in the first row, I would have unique active users that were active between 2021-12-18 and 2021-12-31 (210). In the second row I would have unique active users that were active between 2021-12-17 and 2021-12-30 (170) and so on.