Version 2021
How to 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.
To Create a New Metric Based on an Attribute
- 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
How to Create a Derived Metric Using the Metric Function Editor
How to Create a Derived Metric On a Grid Using a Shortcut
How to Create a Derived Metric by Combining Two Metrics with an Operator
How to Create a Derived Metric by Combining Multiple Metrics
How to Create a Derived Metric by Selecting the Aggregation Function
How to Create a Derived Metric from Scratch Using the Metric Formula Editor
How to Add Conditional Calculations to a Derived Metric Using the If and Case Functions
How to Change the Aggregation and Subtotal Behavior for a Derived Metric
How to Provide Statistical Analysis from R Analytics
How to Edit Derived Metrics from the Dossier
How to Rename Derived Metrics from the Dossier
How to Delete Derived Metrics from the Dossier