MicroStrategy ONE

How to Create a Level Metric

To create a metric, you must define the metric's formula, which consists of the following:

  • Function: The calculation applied to your business data, such as Sum or Count. Depending on how you create the metric, your metric may contain multiple functions.
  • Expression: The business data from your data source. The expression can contain business facts, attributes, or other metrics.
  1. In the Datasets panel click the menu icon and choose Create Metric.
  2. Enter a name for the new metric in the text box.
  3. Select the function and the metric you would like to use from the drop-downs.
  4. Define the target attribute for the level metric by selecting it from the Level drop-down.
  5. You can change the grouping and filtering behavior of the level metric by clicking the menu icon next to the level drop-down.
  6. Click Switch to Formula Editor and click Validate to check the metric expression.
  7. Click Save.