8 Replies Latest reply on Apr 26, 2018 9:11 AM by Jim Dehner

    Calculating outliers using standard deviation

    james.evans.10

      I am trying to create a dimension to use as a filter to filter out data that lies above 3 standard deviations using a table calculation that looks like this:

       

      IF [Total Concentration ] > 3*[Standard Deviation ] THEN 'Outlier'

      ELSE 'Non-Outlier'

      END

       

      "Total Concentration" is a table calc that looks like: {Fixed [ID #] : AVG([Measure 1]*4) +AVG( [Measure2]*10) + AVG([Measure3]*1) + AVG([Measure4]*10)}

      "Standard Deviation" is simply "STDEVP[Total Concentration]"

       

      I am getting the error message because I cannot mix aggregate and non-aggregate arguments, but I feel like I'm pretty close. Can anyone help?

       

      Thanks!