4 Replies Latest reply on Oct 25, 2016 7:59 AM by Ralph Stauffer

    Table Calculations for Control Charts-Very Urgent requirement

    Monika G

      Hello all,

       

      As per my requirement, I would like to plot a Control chart with Calculations as below:

       

      X_Bar =  Average.

      Note: Average = Window Average

       

      R_Bar = Abs(Moving difference across table from Previous Value) / (Count of total rows -1)

       

      Lower Control Limit (LCL) = X_Bar - 2.66 * R_Bar

      Upper Control Limit (UCL) = X_Bar + 2.66 * R_Bar

                                                                        where 2.66 is constant.

       

      Can anyone please suggest me how to create Calculated fields in Tableau to achieve the above.

       

      Please find the attached Excel with sample data and calculations in Excel for this requirement.

       

      Thank you in advance.

       

      Monika.