Version 2021

Create a Derived Metric by Combining Two Metrics with an Operator

You can create a new metric by combining two metrics with an arithmetic operator. These metrics can be an existing metrics or values you enter. Arithmetic operators allow you to add, subtract, multiply, divide, or average metrics.

You estimate that future revenue is 10% higher than your current revenue. To include this estimate, multiply the Revenue metric by 1.1. In addition, you can create a metric that calculates the difference between the metrics as a percentage.

  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 Calculation.
  3. The selected metric appears, by default, as the first metric in the calculation. If necessary, you can select a different metric or enter a value.
  4. Select the arithmetic operator to combine the metrics.
  5. In the second drop-down, select the second metric to use in the calculation or enter a value.
  6. Click OK.

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 Multiple Metrics

Create a Derived Metric by Selecting the Aggregation Function

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