MicroStrategy ONE
Using rank and percent-to-total metric analysis
A derived metric is a calculation based on metric data included in the report definition. You can use derived metrics to perform column math, that is, calculations on metrics included in the report definition, without regenerating or re-executing SQL against the data warehouse.
A subset of derived metrics displays:
-
The percent in relation to a selected total of each item affected by the metric
-
Display a ranking number to the metric values for a given attribute
These can be quickly created using shortcut metrics. Shortcut metrics are a set of quick metrics you can create on the fly for a given report, based on the metrics already in the report. Shortcut metrics include:
-
Percent-to-total shortcut metrics, which display the percent in relation to a selected total of each item affected by the metric. To create this type of shortcut metric, see Creating percent-to-total shortcut metrics.
-
Rank shortcut metrics, which apply a ranking number to the metric values for a given attribute. To create this type of shortcut metric, see Creating rank shortcut metrics.
-
Transformation shortcut metrics, which apply offset values, such as "four months ago," to an attribute that you select. To create this type of shortcut metric, see Creating transformation shortcut metrics.
All shortcut metrics are derived metrics, except for transformation shortcut metrics. Transformation shortcut metrics must be calculated in SQL and are therefore only available to users that have the Modify the list of Report Objects (use Object Browser) privilege. Because they must be calculated, the report re-executes to display the new metric. Reports are not re-executed when other shortcut metrics are created.