Moving standard deviation (of a sample)

Returns the moving standard deviation based on a list of values that is a sample of the population. The calculation can be restarted based on attributes set in the function parameters.

Syntax

MovingStDev<BreakBy = {}, SortBy = ()>(Argument, WindowSize)

• BreakBy is the attribute where the calculation restarts.

• SortBy is the attribute or metric by which the data is sorted.

• Argument is a metric representing a list of values.

• WindowSize is a positive integer indicating the number of values to use in each calculation.

For additional information on and an example of this function, refer to the MicroStrategy Functions Reference.