I am attempting to create the below, which I can do with a Std Dev number calculated and hard coded. I am looking to have it variable, so when filters change this will update.
If I run the below it generates the StDev of 478
Stdev(AGGR(SUM(UNIT_COUNT * [OMS_Units.Line Quantity]),[Created.Fiscal Week]))
If I run the below I don't get any line data:
RANGEAVG(ABOVE(SUM(UNT_COUNT * [OMS_Units.Line Quantity]),0,13))+Stdev(AGGR(SUM(UNIT_COUNT * [OMS_Units.Line Quantity]),[Created.Fiscal Week]))
Lastly I hard coded below to generate chart, but I need to above to keep chart dynamic with different filters:
RANGEAVG(ABOVE(SUM(UNT_COUNT * [OMS_Units.Line Quantity]),0,13))+487