3 Replies Latest reply on Jul 13, 2018 6:57 AM by Navid Tavoli

    Color-code the points in Control P-chart

    Navid Tavoli

      Hi,

       

      I am creating a control p-chart for a metric like profit ratio (0<X<1). I would like to color code the points, so we can differentiate between the one in the range and the ones out of range.

       

      I have made the calculations of average line, UCL and LCL as following:

       

      P_Bar = WINDOW_SUM(( SUM([profit])) / WINDOW_SUM(SUM([sales])))

       

      LCL = [P_Bar] - 3*(SQRT([P_Bar]*(1-[P_Bar])/SUM([sales])) )

       

      UCL = [P_Bar] + 3*(SQRT([P_Bar]*(1-[P_Bar])/SUM([sales])) )

       

      So, here I am wondering how I can create a calculated field that correctly color codes the in range and out of range points.

      I have attached an example worksheet from superstore.

       

      Thank you