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, 2019 in Tableau by anshuli
974 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, 2019 by Cherukuri
• 33,030 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, 2019 in Tableau by Cherukuri
• 33,030 points
881 views
0 votes
1 answer

Tableau - how to show a legend for a stacked bar chart?

I'm afraid I'm going to get marked ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,020 points
2,152 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
3,107 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,820 points
797 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,951 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,622 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, 2019 in Tableau by Cherukuri
• 33,030 points
997 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, 2019 in Tableau by Cherukuri
• 33,030 points
787 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