MicroStrategy ONE
Create a Derived Metric by Combining Multiple Metrics
You can create a new derived metric by combining the values of multiple metrics. Combine multiple values to add, subtract, multiply, divide, or average metrics. You can calculate minimum (that is, Least) and maximum (that is, Greatest) values, as well as differences between metrics as a percentage (that is, (Metric1-Metric2)/Metric2 or (Metric2-Metric1)/Metric1).
- Open the dossier you want to modify.
- Create a derived metric and reserve it for future use in a visualization. In the Datasets panel, select the metrics you want to combine into a derived metric. Press and hold the Ctrl key to select multiple metrics.
- Right-click the selected metrics, choose Calculation, and the function or formula for combining the metrics.
Related Topics
Introduction to Derived Metrics
Create a Derived Metric Using the Metric Function Editor
Create a Derived Metric On a Grid Using a Shortcut
Create a Derived Metric by Combining Two Metrics with an Operator
Create a Derived Metric by Selecting the Aggregation Function
Create a Derived Metric from an Attribute
Create a Derived Metric from Scratch Using the Metric Formula Editor
Add Conditional Calculations to a Derived Metric Using the If and Case Functions
Change the Aggregation and Subtotal Behavior for a Derived Metric
Provide Statistical Analysis from R Analytics
Edit Derived Metrics from the Dashboard