Hey everyone -
I tried searching the forums here but didn’t find much - is anyone else doing time series analyses? I need to do stats, but here’s what I’m running into (and hence am curious how you’re doing it):
If I do it at the dashboard level, I need tons of columns - one for the moving average, then one to copy the last MA into the current row, then one for the percent difference between those MAs, then another for … it goes on and on. I can’t do that for a dozen metrics. ALSO, at this level, I can’t hide the historical data (30+ days), which I only need to do the aforementioned calculations.
If I do it at the data cube level, I can get all the above done really easily, but then I can’t aggregate on the dashboard level. That is, when you use the expanders on a dashboard, the choices are to sum, avg, etc. to aggregate, and none of those are mathematically accurate, so what’s shown is incorrect (you can’t avg or sum percent changes).
I’m not sure where to go here. I spent 2 days playing with every option I could find, but it didn’t seem to work right. Can anyone share how they do time-based stats or ideas as to how to tackle mine?