Reply
Highlighted
Green Belt
Posts: 93
Registered: ‎10-12-2016

Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)

I posted a requested in the Idea Exchange for a new chart type, Statistical Process Control Charts (link below).  I wanted to ask the Dojo if anyone has done something like this already?  What I really need to be able to include in a line chart are the Mean, UCL and LCL values.  Plotting the actual results with those lines displayed is what I'm trying to accomplish.

 

https://dojo.domo.com/t5/Ideas-Exchange/New-Card-Type-Request-Statistical-Process-Control-Charts/idi...

 

Anyone know how to do this?

Image result for SPC chart example


**You can say "Thank you" by clicking the thumbs up in the post that helped you.
**If the post solves your problem, mark it by clicking on "Accept as Solution"
Moderator
Posts: 102
Registered: ‎01-22-2017

Re: Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)

Is there anyone that could help with this request?

Visitor
Posts: 4
Registered: ‎04-20-2017

Re: Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)

With line graphs, I know there's a way to show average and median lines with some tinkering (under Chart Properties>Grid Lines>Calculated Line).

 

The only other option I can think of is to use for UCL and LCL is to use Chart Properties>Scale Marker Range, enter in your min and max values, and make the lines red like you have them. Of course, you would need to know what those values are and would be static instead of calculated. From there, you can shade the area between the two limits to highlight the area of focus.

 

This may or may not be exactly what you needed, but let me know if that helps.

 

Green Belt
Posts: 93
Registered: ‎10-12-2016

Re: Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)

Thanks @ADerbak, but the UCL and LCL do need to be dynamic for this to really be what I need.  Don't forget, if you support the idea follow the link to the Idea Exchange and "Like" that post please.


**You can say "Thank you" by clicking the thumbs up in the post that helped you.
**If the post solves your problem, mark it by clicking on "Accept as Solution"
Announcements
Customize your Dojo Handle! You can update your Dojo screen name by clicking on My Settings. click here! Thanks!