Filtering Out Data More Than N Standard Deviations From the Mean

Published: 10 Apr 2017
Last Modified Date: 17 Jan 2019


Tableau Desktop


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?