Has anyone had any luck with moving averages with multiple dimensions? For example, I want to see moving 7, 14, 28 day moving average (set as variable) for each of our points of sale (POS) on one line chart. So my dimensions are date and POS. I can see that my formula is working correctly when i use a straight table but when I try a line chart, it will only plot the actuals. Also, if I remove POS which then aggregates them, then the chart works perfectly. Thoughts?
