
1. Re: Standard deviation of a year on year calculation
Jessica Fan May 17, 2016 9:15 AM (in response to ben.ellis)Hi Ben,
Please see the attached workbook for a visualisation on standard deviation (this workbook uses a parameter to allow you to define the number of s.d. you want to see)
You should be able to create fields for the upper and lower bounds of your s.d and plot them as reference bands.
e.g. something like this:
WINDOW_AVG(SUM([Profit]))  WINDOW_STDEV(sum([Profit]))*[Standard Deviation Param]
Hope this helps
Jessica

Standard Deviation.twbx 433.2 KB


2. Re: Standard deviation of a year on year calculation
ben.ellis May 17, 2016 9:49 AM (in response to Jessica Fan)Thanks Jessica this is awesome. One thing I am still struggling with a little bit is that my calculation is based on year on year growth. so its affectively a percentage difference from the percentage mean.
When I try to inject a YoY calculation where you have sum(profit) in the stddev calculation I get the aggregation error.
Not sure if I am explaining this clearly but its the year on year percentage that I am trying to calculate the stddev on.

3. Re: Standard deviation of a year on year calculation
Jessica Fan May 18, 2016 2:02 AM (in response to ben.ellis)Hi Ben,
Can you please share the calculation and the error you see? Or attach the workbook (in twbx format)
Jessica