I have a set of data:
People mon 10
I would like to create a calculated field to measure the moving average...I am able to do the control chart with 3 sigma (+/-), and the out of the box moving average stays on the value number (10,15,20, etc). I would like for the moving range to show 5,5,2,12 instead. any ideas on how to achieve?
This is how I made it work....create a calculated field..."Value" is the name of my data field I am using
ZN(SUM([Value])) - LOOKUP(ZN(SUM([Value])), -1)