Creating a derived metric by selecting the aggregation function

You can create a derived metric by selecting the aggregation function used to calculate values in an existing metric. Aggregation functions are used to calculate subtotals for a metric (for example, Sum, Average, Standard Deviation, Median, etc.).

For instance, you can create a derived metric that calculates the average of the Revenue metric values. The derived metric is automatically named Avg(Revenue), although you can change it.

To Create a New Metric by Selecting an Aggregation Function

1. Open the dossier you want to modify.
2. Create a derived metric and reserve it for future use in a visualization. In the Datasets panel, right-click the metric to use to create a derived metric and choose Aggregate By.
3. Select the aggregation function to use to calculate metric values.