1 of 1 people found this helpful
I do believe Mr Jones gives some solid examples and downloads:
2 of 2 people found this helpful
The links Nathaniel posted are great! A few other points as I've been building control charts over the last couple of months:
- Adding dimensions to the Rows and/or Columns shelves makes it easy to show lots of control charts at once, as a small multiple view. If those dimensions are in a hierarchy (such as the built-in date hierarchy), Tableau Server users can drill-down through the hierarchy and effectively generate their own charts on the fly. One thing to watch out for here is what happens when each chart shrinks: all the mean, SD, and axes lines can make the chart get too busy and obscure the data.
- Dashboards can be used to show a run chart and associated control charts together in one place.
- If you have to make a lot of control charts, play with a couple first to get your design figured out. I've spent too much time adding Reference Lines & formatting charts and have contributed to a couple of feature requests on how to make building control charts easier.
- I've also made use of parameter-driven dimensions (where a calculated field on the Rows or Columns shelf returns a dimension as specified by a parameter) to effectively put multiple control charts for different dimensions in the same view. This can work well for small data sets, for larger ones it can end up slowing down performance of the view.
Thank you Nathaniel and Jonathan!
Very helpful and fast replies I must say.
I'm very happy to see this has already been covered.
The Spotfire implementation where changes to the limits over time is also covered:
Being able to changle limits and show multiple limits in the same chart seems to be the only thing missing...
Attached is a workbook showing a couple of ways to change the limits over time. Neither way works as well as I'd like, but it gets there. I created a discrete dimension (Before/After) based on a given date (in this case, a parameter) and then used that on the Columns shelf to generate different panes that could have their own reference lines. Additional process changes could be reflected by making the discrete dimension calculation have more details.
process changes.twbx.zip 196.2 KB
Glad you guys found the tutorial & found it helpful!
Let me know if this helps in terms of constructing different types of control charts. This is a WIP so if you find any mistakes please let me know! These are on Tableau public so feel free to download the workbook and play around with the calcs.