Loading

Filtering Out Data More Than N Standard Deviations From the Mean

Дата публикации: Apr 28, 2025
Действия
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.

Дополнительные ресурсы
An EXCLUDE LOD can likely be used in place of FIXED. If FIXED is used, keep in mind Tableau's order of operations.
Номер статьи базы знаний

001458052

Вложения

Filtering With STD Dev.twbx

1235 KB

 
Загрузка
Salesforce Help | Article