Hello and thanks for the response.
Unfortunately, windowSum didn’t quite work because I need a rolling distinct. Figured a workaround for now.
My question now is around filtering. I want to display the current month and last six months. So I create a filter for them. The filter also ends up filtering the data as such.
I need to be able to display only the current and last six months but the calculation should be taking the last 12 months into account. Is there any way to do that?
Thanks a lot
I am trying to implement similar thing, windowsum is not working for me. Windowsum is adding the last 12 month distinct counts (sum of each month distinct count), but I want to calculate the distinct count for the last 12 months data for each month in the dataset. Could you please shed somelight on how did you achieve this? Your help is appreciated.
Hi Sindhu! I used a formula to only count IDs the first time they occurred in the time period and then do a running sum across these counts that way ensuring the ID is counted only once for the time peirod. Unfortunately this only works for YTD/same year’s data. Here’s the formula