I have 2 questions:
is the User Count 7-Day Avg actually “total distinct user count for last 7 days”
here’s the formula calculated field:
The formula contains the word windowAvg, but it’s always a lot higher than distinct total user count per each day - so it can’t be the average?
how to calculate distinct user count for rolling 30 days? (and plot it on the same chart). I have tried various functions, but no luck. Not much documentation or examples.