02-12-2015 05:12 PM
I'm trying to create a bar/line chart by month. I need the caluclation to be a rolling Standard Deviation (uses previous X months as data points instead of the whole data set at once). Does anyone know a way to calculate this?
Also, is there a way to calculate standard deviation off an aggregated measure (percent) instead of just a measure?
Any help would be greatly appreciated!
02-12-2015 07:02 PM
There are lots of people who have "date" variables that are character and when you try to group those it gets very messy. For charting purposes I'm going to assume that you're willing to accept a summary and not try to have the graphing program calculate it. Is that correct?