This content has been marked as final.
Show 2 replies
-
1. Re: Moving Average
Yuriy FalNov 21, 2018 6:39 PM (in response to magdalena.bielaski.0)
Hi Magdalena,
Please refer to this thread for a possible answer:
Re: Distinct active users in prior 90 days for a given week
As for your second question, you'd have to distinguish
between the zero sales (the evidence of absence of sales)
and the null sales (the absence of evidence of sales).
Hope it could help a bit.
Yours,
Yuri
-
2. Re: Moving Average
Paul Wachtler Nov 21, 2018 7:00 PM (in response to magdalena.bielaski.0)Hi Magdalena,
May I ask why you don't want to use a window calculation for figuring out the moving average? That's the most direct way of doing it. I'm not sure how to do it otherwise.
Best,
Paul