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.