Creating a derived metric by selecting the aggregation function

You can create new metrics (called derived metrics) based on metrics that have already been added to a dashboard. For a more detailed description of derived metrics, see Creating a metric based on existing objects: Derived metrics.

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 the metric. Examples are Sum, Average, Standard Deviation, and Median. For example, 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. See Editing or deleting derived metrics in a dashboard for steps to rename a derived metric.

You can create a derived metric and immediately display it on a visualization, or you can create and add a derived metric to a dashboard without adding it to a specific visualization. Both methods add the derived metric to the list of dataset objects in the dashboard's Datasets panel, so that you can use the metric in visualizations, text fields, and so on.

Prerequisites

If you want to add the derived metric to a visualization, you must have already created the visualization. For steps, see About visualizations.
You must have the Web Edit Dashboard and Web Run Dashboard privileges.

To create a new metric by selecting an aggregation function

1 Click the name of the dashboard to run it.
2 When you create and add a derived metric to a dashboard, you can also add the derived metric immediately to a specific visualization to be displayed. Do one of the following:
To create the metric without adding it to a visualization, from the Datasets panel, right-click the metric to use to create the derived metric, and select Aggregate By.
To create the metric and add it immediately to a specific visualization, from the visualization’s Editor panel, right-click the metric to use to create the derived metric, and select Aggregate By.
3 Select the aggregation function to use to calculate metric values. The new metric is added to the dashboard.

Related topics

Creating a metric based on existing objects: Derived metrics
Editing or deleting derived metrics in a dashboard