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.
- In the Datasets panel click the menu icon and choose Create Metric.
- Enter a name for the new metric in the text box.
- Select the function and the metric you would like to use from the drop-downs.
- Define the target attribute for the level metric by selecting it from the Level drop-down.
- You can change the grouping and filtering behavior of the level metric by clicking the menu icon next to the level drop-down.
- Click Switch to Formula Editor and click Validate to check the metric expression.
- Click Save.