AnsweredAssumed Answered

Rolling 3 month Average in a dataview

Question asked by aelvin@board.com Employee on Nov 1, 2017
Latest reply on Nov 2, 2017 by aelvin@board.com

Can I create a moving average in a dataview? For example I would like 12 months of data as Bars on a chart and then have a 3 month moving average as a line on the chart so lets say that periods 9,10,11,12 had the values 38, 40, 45, 49 on my chart the bar for period 12 would be at 49 and the 3 month ave for period 12 would be 44.6, and for period 11 the bar would be at 45 and the line would be at 41.  Thanks!

Outcomes