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