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.
- Open the dossier you want to modify.
-
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 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