I am trying to find outliers for some production orders.
I want to find the production orders which have unusual high costs.
I thought I get the median (or mean) +/- the standard deviation and figure out which orders are above/below.
Median / average work as long as my table only includes Articles. As soon as I get the order in as well, the median is no longer the median for all orders of the same article.
With this I cannot add the standard deviation to identify which order is an outlier.
- How do I get the median to be the same for each order of the same article?
- Is there a better approach to find outliers?
I attach some simple data examples and really hope someone can push me in the right direction.
Median Calculation.pbix (37.0 KB)
Thanks in advance