Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
AdamPi
Contributor
Contributor

Shift Line Chart Guardrails to Std Dev from the Average

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

db2bfa35f1864945a87cef6c0335f253.png

0 Replies