Hi I think I understand what you are saying -
the date 90 days (calendar days) ago is dateadd('day',-90,today())
so the 90 day period is [your date] >= dateadd('day',-90,today()) and [your date]<= today() - you can use that as a filter on the date set to True
then use window_count(count(users id)) / Window_count(countd([your date]))
that should do it - note I did not test so you may need to play with the syntax
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Yes, I understood that step and it worked. I meant step 2 is still not working. When you referenced this formula: "window_count(count(users id)) / Window_count(countd([your date]))".
I'm not sure what to do with that. It is labeled in my screenshot as "Average Daily Users"
Apologies the formula should be
WINDOW_SUM(count([Order ID]))/window_count(countd([Ship Date]))
wanted to sum the count of the individual days