MicroStrategy ONE

Moving maximum

Returns the moving maximum value by comparing current and preceding rows as defined in the function arguments The calculation can be restarted based on attributes set in the function parameters.

Syntax

MovingMaxBreakBy = {}, 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 a metric representing a list of numbers.

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

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