Hi @Awan,
Thanks for the additional information. I’d be curious to know when you tested out the suggestions above, did you see the value you were expecting?
In regards to your mismatched aggregation; the problem is likely due to the upper and/or lower bound calculations. That error basically means that one of your fields needs to be aggregated so they can be used together in a calculation. An example:
Returns aggregation error: ifelse(sum({Sales}) > 1000, {Product}, NULL)
Doesn’t return error: ifelse({Sales} > 1000, {Product}, NULL)
Also doesn’t: ifelse(sumOver({Sales}, [{Customer}], PRE_AGG) > 1000, {Product}, NULL)
Since you are utilizing an aggregation in the actual value for outlier calculation, I believe the issue is with the other 2 fields you are using. While it may look messy in the calculated field, it may be easier to see what is causing the error if you utilize the full calculations in the Outlier Flag calculation rather than a bunch of calculated fields.
Additionally, it may be easier to assist further if you’re able to upload a sample of your analysis to the Quick Sight Arena view with anonymized data.