Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)
How to make a control chart in tableau?

1 Answer

0 votes
by (47.2k points)
edited by

Hi Vaibhav,
Control chart is used to see outliers for period of time or data. Follow these steps to make control chart:
1. Make a chart (line chart/scatter plot, etc) that you want to check the outliers or those odd one out.
2. calculated field need to be created that performs average of window elements by WINDOW_AVG().
3. Create calculated field to fix the boundaries of outliers using standard deviation and average.
       Define limit as window_avg([Field])  window_stdev([Field])
4. Create Calculated field to find the lower and upper limit of boundaries.
5. Now Drag and drop all the fields in details shelf.
6. Now switch to analytics pane and add reference lines for all 3, select each of them and plot the lines.
7. Then format all lines and edit their font and styles.

Hope this helps you.

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.

Related questions

0 votes
1 answer
asked Oct 16, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Dec 22, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer

Browse Categories