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
32 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,940 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
• 13,940 points
9 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,200 points
77 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
12 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,470 points
67 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,200 points
945 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,200 points
36 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
• 13,940 points
10 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
• 13,940 points
11 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.