KNOWLEDGE BASE

Filtering Out Data More Than N Standard Deviations From the Mean


Published: 10 Apr 2017
Last Modified Date: 26 Jul 2017

Environment

Tableau Desktop

Answer

The calculation needed to filter data outside of N standard deviations of the mean will depend on how the data is organized and what is used for the 'population'. To filter data outside of 2 standard deviations in a simple view, you can use a calculation similar to the following, where N was equal to 2:
  [Sales]>={ FIXED :AVG([Sales])-N*STDEV([Sales])} AND [Sales]<={ FIXED :AVG([Sales])+N*STDEV([Sales])}

See the attached packaged workbook (.twbx) for an example.

Did this article resolve the issue?