How to make an average excluding the 2% biggest values ?
Hello, I have a list of incidents with a duration and i would like to make an average but excluding the 2% biggest values
for example i have :
duration / in scope
and i make a sum(duration) / sum(scope)
but i want to exclude the 2% biggest values of duration. How can I do ? If i remove the 3000 I also need to take into account that it was 0 in scope .. I presume i can do it with a aggr but i can't find