MicroStrategy ONE
How to Create a Rank Shortcut Metric
Shortcut metrics are a quick way to add new metrics based on the existing metrics of a report, including a report displayed on a document.
Rank shortcut metrics apply a ranking number to the metric values for a given attribute. When you create a rank shortcut metric, you can determine break-by options for each attribute on the report. Use the rank function to show the relative position of a given value in relation to other values on a report.
Rank shortcut metrics calculate subtotals and dynamic aggregation for functions that have a default dynamic aggregation (such as sum or minimum). If the shortcut metric is based on an attribute, it also calculates correctly for functions that do not have a default dynamic aggregation function (such as average and count distinct). For a complete list of the functions, as well as more details about dynamic aggregation, see the In-memory Analytics Help.
Shortcut metrics are available only if DHTML is enabled. See How to Enable DHTML in MicroStrategy Web.
The report must be displayed as a either a grid or as both a grid and a graph.
To Create a Rank Shortcut Metric
- To create a shortcut metric on a report, click the report's name to execute it.
- Right-click the column(s) or row(s) to rank.
- Select Insert Metric and point to Rank.
- Select the break-by value from the list by selecting one of the Break by attribute name options. This determines the business attributes you are ranking.
- Select either Ascending or Descending.