MicroStrategy ONE

Create a Derived Metric Using the Metric Function Editor

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You can create new metrics, called derived metrics, based on attributes and metrics that have already been added to a dashboard.

You can create a new metric by subtracting the values of one metric from the values of another metric, such as Revenue Forecast - Revenue. You can rank a metric's value from least to greatest, or display metric values as percentages of an accumulated total.

Create a Derived Metric Using the Metric Function Editor

  1. Open the dashboard you want to modify.
  2. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric.

  3. Enter a name for the metric in the Metric Name field.
  4. Enter a description of your derived metric in the Description field.
  5. To locate a function, enter its name in Search . You can also browse for a function by selecting a function category (that is, Basic Functions, String Functions, etc.) from the drop-down.

    Click on functions in the left pane to view a corresponding description at the bottom of the dialog. Then, click Details to view more information about the function and its arguments in the Functions Reference . See Add Conditional Calculations to a Derived Metric Using the If and Case Functions for more information about the If and Case functions.

  6. Click a function to add it to the derived metric definition in the right pane.
  7. If you selected an aggregation function (that is, grouping function), such as First, Maximum, or Sum, the Level and Filter fields appear under Function Parameters. Go to step 8.
  8. If you selected a non-aggregation function, such as data mining, date, OLAP, and ranking functions, options appear that allow you to define the input values (that is, arguments) for the function, as well as any parameters that determine the behavior of the function. Enter the appropriate options and go to step 12.
  9. You can define function parameters, such as whether to use all values in the calculation or calculate using only unique values. Click Function Parameters, select the appropriate options to define the parameters, and click OK.
  10. The function is calculated at the level of the attributes on the visualization on which the metric is placed, by default. You can specify the attributes to use in the metric calculation, regardless of what is contained on any visualization that the metric is placed on. To change the level, select an attribute from the Level drop-down. You can also add multiple attributes.

    If a visualization contains Region and Category, by default the metric calculates regional and category values on that visualization. If you select Region as the level, the metric calculates the regional revenue values on that visualization; it does not include a breakdown by Category. This allows you to compare revenue across regions.

  11. You can add advanced filtering to your metric. Click Add Filter to open the New Qualification dialog. See Introduction to Advanced Filtering for more information.
  12. If the Sort By field appears, select options for sorting the data.
  13. Click Save.

Aggregation and subtotal behavior is automatically determined by default. You can change that behavior, to specify whether the derived metric is calculated using the whole dataset or calculated using the data in the visualization that it is placed on. See Change the Aggregation and Subtotal Behavior for a Derived Metric for more information.

Related Topics

Introduction to Metrics

Introduction to Derived Metrics

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 Combining Multiple Metrics

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

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