Tableau - control chart

0 votes
How to make a control chart in tableau?
Mar 29 in Tableau by Anitha
26 views

1 answer to this question.

0 votes
Hi,

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. Create calculated field 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. Go to analytics pane and add reference lines for all 3, select each of them and plot the lines.

7. Now format all lines and edit their font and styles.

Hope this helps you.
answered Mar 29 by Cherukuri
• 27,960 points

Related Questions In Tableau

0 votes
1 answer

Creating a dual axis chart with same measure in Tableau

Yes, this is possible. Drop the measure in ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
1,314 views
0 votes
1 answer

Tableau chart with mixed colors

It is as simple as dragging the ...READ MORE

answered Jun 28, 2018 in Tableau by Atul
• 5,530 points
112 views
+1 vote
1 answer

Non-overlaid measures in dual axis chart within Tableau

The missing step is to specify the ...READ MORE

answered Jul 23, 2018 in Tableau by Atul
• 10,240 points
41 views
0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
616 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,020 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
89 views
+2 votes
1 answer
0 votes
1 answer

Displaying Aggregations across bar chart in Tableau

Hi Sindhu, 1.You can use average lines to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 27,960 points
57 views
0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 27,960 points
809 views