Rolling 30 Calculations: Counts NOT Avg/Sum
Hi all! I found this article: https://community.sisense.com/t5/knowledge/rolling-trailing-12-months/ta-p/565 on how to do rolling calculations if you have averages or sums. Unfortunately, I need t...
Forum Discussion
Unfortunately, that gives me the sum of the unique ids each day for 30 days b/c my data set has the same account listed on multiple days (all days it was paying).
I need to get the unique count over the 30 days (so each account is only counted one time, even if it appears on multiple days). I'll keep playing around and see what I can find
