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).

  1. Open the dashboard you want to modify.
  2. 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.
  3. Right-click the selected metrics, choose Calculation, and the function or formula for combining the metrics.

Related Topics

Introduction to Metrics

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

Rename Derived Metrics from the Dashboard

Delete Derived Metrics from the Dashboard