MicroStrategy ONE

Moving count

Returns the moving count of a list of values. The calculation can be restarted based on the attributes set in the functions parameters.

Syntax

MovingCount<BreakBy = {}, 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 values.

  • WindowSize is a positive integer indicating the highest number to use in the count.

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