How to remove a lowest value when calculating Average

I have a data of 3 weeks for each users. what I want is to calculate average for each users. However for Jon, we can see that week 3 was an outlier (standard deviation > 7% ) based on our rule. so when calculation average for Jon, we would like to remove that value. How can I do it? thank you!

Can you make a calculated field of standard deviation and filter out your rule?

Something like this: stdev({field},[{name}])

Then filter it

1 Like

Hey Max, I am trying to find Avg within low and High limit of SD here Countif Nesting Aggregate function
could you take a look please? thank you