Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thanks Chris, this helped a lot.