This content has been marked as final.
Show 3 replies

1. Re: How do I get the average of a set of data that is within x standard deviations?
Bill Lyons Mar 5, 2016 2:40 PM (in response to Jim Nielsen)Lacking any example file from you, I created one using the Tableau Superstore database. In the attached example (v9.2), you can see calculations of average of order profit, standard deviation of order profit, z score, and whether a particular order is an outlier based on a z score parameter. You will also see reference lines for the overall average and average of orders which are not outliers based on the parameter.
Is that helpful?

Outlier calculation example.twbx 1,010.1 KB


2. Re: How do I get the average of a set of data that is within x standard deviations?
Jim Nielsen Mar 7, 2016 4:24 AM (in response to Bill Lyons)Bill,
Thanks so much. This is exactly what I was trying to accomplish.
Regards,
Jim

3. Re: How do I get the average of a set of data that is within x standard deviations?
Bill Lyons Mar 7, 2016 9:10 AM (in response to Jim Nielsen)Always happy to help.