MicroStrategy ONE

Changing the sort order of rank shortcut metrics

By default, a rank shortcut metric ranks values from low to high in ascending order. You can change the metric to rank in descending order by editing the metric, as described in the procedure below.

Prerequisite

  • You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. These privileges are part of OLAP Services.

  • You must have the MicroStrategy OLAP Services product to create shortcut metrics. If you would like to evaluate OLAP Services, contact your MicroStrategy Account Executive or e-mail MicroStrategy directly at info@microstrategy.com.

To change the ranking order of a rank shortcut metric

  1. In MicroStrategy Developer, open a report that contains a rank shortcut metric.

  2. Right-click the rank shortcut metric and select Edit. The Input Metric Formula dialog box opens and displays the metric formula.

  3. Modify the ranking order by modifying the ASC=ranking_order parameter, as described below:

    • ASC=True: (Default) Values are ranked from least to greatest in ascending order. Therefore, the smallest value has a rank of 1 and the largest value has a rank equal to the total number of items being ranked within a given break by grouping.

    • ASC=False: Values are ranked from greatest to least in descending order. Therefore, the largest value has a rank of 1 and the smallest value has a rank equal to the total number of items being ranked within a given break by grouping.

  4. Click Validate to confirm that the metric definition is valid for use by the MicroStrategy engine.

  5. Click OK to return to the Report Editor. Any rank ordering changes are displayed in the report.

Related Topics