Skip to main content
Version: Early Access

Creating a derived metric by combining multiple metrics

You can create a new derived metric by combining the values of multiple metrics. Combine multiple values to add, subtract, multiply, divide, or average metrics. You can calculate minimum (that is, Least) and maximum (that is, Greatest) values, as well as differences between metrics as a percentage (that is, (Metric1-Metric2)/Metric2 or (Metric2-Metric1)/Metric1).

To Create a New Metric by Combining the Values of Multiple Metrics

  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, select the metrics you want to combine into a derived metric. Press and hold the Ctrl key to select multiple metrics.
  3. Right-click the selected metrics, choose Calculation, and the function or formula for combining the metrics.