Version 2021

Create 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.).

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.

  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.

Related Topics

Introduction to Metrics

Introduction to Derived Metrics

Create a Derived Metric Using the Metric Function Editor

Create a Derived Metric On a Grid Using a Shortcut

Create a Derived Metric by Combining Two Metrics with an Operator

Create a Derived Metric by Combining Multiple Metrics

Create a Derived Metric from an Attribute

Create a Derived Metric from Scratch Using the Metric Formula Editor

Add Conditional Calculations to a Derived Metric Using the If and Case Functions

Change the Aggregation and Subtotal Behavior for a Derived Metric

Provide Statistical Analysis from R Analytics

Edit Derived Metrics from the Dossier

Rename Derived Metrics from the Dossier

Delete Derived Metrics from the Dossier