How to show outliers for a given set of points.

0 votes
How to show outliers for a given set of points and show boundary for outliers for line chart by using average?
Apr 17 in Tableau by anshuli
43 views

1 answer to this question.

0 votes
Hi Anshuli,

Follow below steps:

1. Create a line chart with required points.

2. Create a calculated field to find the avg for the points lying in the sheet.

AVG = WINDOW_AVG(SUM([Sales]))

3. Create another calculated field to find standard deviation of the points on the sheet.

SD = WINDOW_STDEV(SUM([Sales]))

4. Create another sheet to find the boundary line of the line chart to find outliers.

Upper = AVG + SD,  Lower = AVG - SD .

5. Use created fields as reference lines and show the line chart to show outliers.

Hope this helps you.
answered Apr 17 by Cherukuri
• 17,870 points

Related Questions In Tableau

0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2 in Tableau by Cherukuri
• 17,870 points
14 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
106 views
0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
14 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
108 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
1,367 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
50 views
+2 votes
1 answer
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 17,870 points
19 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 17,870 points
21 views