MicroStrategy ONE

Moving minimum

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

Syntax

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

  • BreakBy is the attribute indicating where the calculation restarts.

  • SortBy is the attribute 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 Functions Reference.