MicroStrategy ONE

Rank

In rank functions, you specify the metric to be ranked and whether to rank in ascending or descending order. You can also specify whether to break by an attribute.

The level of the rank depends on the level in the report. For example, the following metric, named Revenue Rank, combined with customer on a report shows the highest revenue customer as number one.

Rank(Revenue)

Adding a parameter to break by year displays the customer generating the highest revenue in each year as number one. The metric definition for this Revenue Rank by Year metric is shown below:

Rank<BreakBy={Year}>(Revenue)

The document shown below uses two different reports:

  • The "Top 10" reports are created from the same report, which uses the Revenue Rank by Year metric. Each of the reports on the document is filtered to display a particular year and the top ten Revenue Rank by Year values for that year.
  • The "Overall Ranking" report is created from a report that uses the Revenue Rank metric.

    The image above shows a MicroStrategy document. Documents can display different reports within the same display, as shown in this example. For more information on using documents in general, see the Document and Dashboard Analysis Guide; for steps to create documents, see the Document Creation Help.