Standard Deviation on Line chart

[tapassingh]

I am building line chart which shows trend of users across a period (Week, 1 Month,3 Month, 6 Month, Year). I want to plot/highlight Standard deviation on that chart and mark lines with circles when it goes above or below the deviation. Like nelsons rule.

[chrismarlow]

Hi,

You can use Total with Avg and StDev to lines for the bounds & then use a formula to return nulls when you are not below/above to get something like the below;

I've attached QVW, but I am on personal edition so you may not be able to open.

Cheers,

Chris.

[tapassingh]

Thanks Chris, this helped a lot.