MicroStrategy ONE

Moving standard deviation (of a population)

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

Syntax

MovingStDevpBreakBy = {}, SortBy = ()(Argument, WindowSize)

  • BreakBy is the attribute indicating where the calculation restarts.

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

  • Argument is 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.