Does anyone know how one can calculate a Moving Standard Deviation? We want the Standard Deviation for a given Attribute to slide over time instead of a single value for all the entries. Similar to how Cognos delivers an Average function and also a Moving_Average function (where you can input a time period). How can we create that "Moving" component for the Standard Deviation function?
thanks!
Evan