MicroStrategy ONE

First

Returns the result of an aggregate applied over a set of rows that ranks as the first within a specified order.

This is a group-value function that shares the SortBy capability of the OLAP functions.

Syntax

First<FactID, SortBy>(Argument)

  • FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.

  • SortBy is a parameter that allows you to define the attribute or metric on which to sort the data; if no SortBy is defined, then they are sorted by the values.

  • Argument is an attribute, fact, or metric representing a list of values.

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