MicroStrategy ONE

First value in range

Returns the first value in a range of values. The calculations can be restarted based on attributes set in the function parameters. This restart capability differentiates FirstInRange from First. While First is a group-value function and takes both facts and metrics as argument input, FirstInRange is an OLAP function and takes only metrics as argument input.

Syntax

FirstInRange<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 a list of value.

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