Hello everyone,
I'm wondering whether it is possible to ignore statistical outliers (fe. >2*standarddeviation (alternatives are welcome as well)) from the calculation of an performance graph.
Formula below currently calculates the blue line shown above.
AVG(aggr((Sum(Aggr(fabs(Date(avg(TOTAL <[inkooporderregel link]>
Aggr(
If(volgnrhist = Max(TOTAL <[inkooporderregel link]> volgnrhist),Datum_uiterlijke_leverdatum),
[inkooporderregel link],volgnrhist)
))
-aggr(max(Datum_ontvangst),[inkooporderregel link])),[inkooporderregel link]))),[inkooporderregel link]))
It represents the absolute deviation in actual delivery date in comparisson to the last confirmed delivery date
| Line | Confirmed delivery date | Actual delivery date | Absolute deviation |
| 1 | 15-02-18 | 19-02-18 | 4 |
| 2 | 15-02-18 | 19-02-18 | 4 |
| 3 | 15-02-18 | 19-02-18 | 4 |
| 4 | 15-02-18 | 19-02-18 | 4 |
| 5 | 23-02-18 | 19-02-18 | 4 |
| 6 | 13-03-18 | 19-02-18 | 22 |
The Average deviation would be 7 and standarddeviation is 7.34. In case where I would see deviations exceeding the average by 2*standarddeviation as outliers I would see 22 as an outlier and the average with the outlier not taken into acoount is 4.
Thus, Can anyone help me to ingore outliers in such a calculation?
Note: I can not work with a min level or max level (it should be a statistical outlier)
Many thanks in advance
Thomas
