Tableau - control chart

0 votes
How to make a control chart in tableau?
Mar 29, 2019 in Tableau by Anitha
660 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, 2019 by Cherukuri
• 33,030 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 29, 2018 in Tableau by Atul
• 10,240 points
8,405 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 ffdfd
• 5,550 points
1,730 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 24, 2018 in Tableau by Atul
• 10,240 points
582 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
3,653 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
9,595 views
+2 votes
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
1,420 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, 2019 in Tableau by Cherukuri
• 33,030 points
1,896 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, 2019 in Tableau by Cherukuri
• 33,030 points
5,203 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP