MicroStrategy ONE

Create Derived Metrics

Calculations like addition, subtraction, and average can help businesses better understand data on HyperIntelligence Cards. You can create derived metrics on the fly without modifying or adding desired metrics to your dataset.

  1. In the top left of the Card Editor, click New Metric.

  2. In the Metric Editor, add in the calculation for the metric and validate it.

    You can create derived metrics using the Metric Function Editor or Metric Formula Editor.

  3. Enter a name in the Metric Name field.
  4. Click Save.
  5. Drag the newly created derived metric to your card.

    Derived metrics are signified by the fx in the left pane.

  6. To rename or delete your derived metric, right-click it and choose an option.