Forum Discussion

walterdp's avatar
walterdp
Helper I
4 years ago
Solved

How to create a control chart with dynamic limits (based on different filters)

I would like to create a control chart with UCL, LCL and average that can adjust based on the filters I apply. For example, the line charts below have no filter applied

 

 

But if I select a different "Estado" or "Periodo" or even if I select a bar on the chart in the middle of the image, the "average" changes. I want to have the same but for UCL and LCL.

 

 

 

Thanks!


Walter

Need Help

3 Replies

  • walterdp's avatar
    walterdp
    Helper I
    4 years ago

    Hi, Anonymous:

     

    Thanks for replying. I briefly read the articles you shared and I believe they are not what I need. What I'm looking for is a way to calculate UCL, LCL and average to use them in a control chart and make those measurements dynamic, based on the filters I can use as explained in the initial post.

     

    Thanks


    W  

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello Walter,

       

      I have the same question. I need to add extra 3 filters for the control chart.
      Have you found a solution for this?