MicroStrategy ONE

Create a Derived Metric from an Attribute

You can create a derived metric from an existing attribute. The existing attribute is duplicated and changed into a metric. The metric's definition depends on the definition of the attribute.

If the attribute contains numeric values, the value of the metric is calculated based on the sum of the elements in the attribute.

The Age attribute contains employee age data, as numeric values. You want to calculate the average age of employees in different departments. Create a derived metric from the Age attribute, which aggregates all the employees' ages. You can then average the Age metric for each department.

If the attribute does not contain numeric values, the metric is created as a count metric. The derived metric counts the number of attribute elements.

The Region attribute contains text values: Northeast, Midwest, Southwest, etc., for a total of 12 regions. You need to know the number of regions, so you create a derived metric from the Region attribute. The derived metric's value is 12.

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

    The Duplicate as Metric option is not available for a derived attribute.

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

Create a Derived Metric by Selecting the Aggregation Function

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