How to remove a lowest value when calculating Average

[Alana]

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!

[Max]

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

stdev - Amazon QuickSight

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

Then filter it

[Alana]

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