1 Reply Latest reply on Apr 19, 2012 5:34 AM by Eric Mayberry

    Control Chart and Moving Average

    Eric Mayberry

      I have a set of data:

       

                     date     value

      People     mon     10

                     tues     15

                     wed      20                   

                     thur      22

                     fri         34

       

      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?

       

      Thanks,

      Eric