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

  1. Open the dossier 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

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