MicroStrategy ONE

Running maximum

Returns the running maximum value in a list of values by comparing current and preceding values. The evaluation can restart based on attributes identified in the parameter settings.

Syntax

RunningMax<BreakBy = {}, SortBy = ()>(Argument)

  • 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 the list of values.

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