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 new metric by combining existing metrics with an arithmetic operator. Arithmetic operators allow you to add, subtract, multiply, divide, or average the selected metrics. You can find the minimum or maximum value of the selected metrics. Use a constant in the derived metric. For example, you estimate your future revenue will be 10% higher than your current revenue. To display this estimate, multiply the Revenue metric by 1.1. You can also create a metric that calculates the difference between the metrics as a percentage.
See the table below for steps to create a derived metric using these various methods.
| To... | See... |
|---|---|
| Combine two metrics with an arithmetic operator | |
| Combine three or more metrics with an arithmetic operator | To create a new metric by combining the values of multiple metrics |
| Calculate the average, maximum, or minimum of metrics | To create a new metric by combining the values of multiple metrics |
| Select a metric formula, such as Metric1/Metric or Metric2-Metric1 | To create a new metric by combining the values of multiple metrics |
| Use a constant in the derived metric | To create a new metric based on an arithmetic calculation |
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.
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 Edit Dashboard and Run Dashboard privileges.
To create a new metric based on an arithmetic calculation:
Click the name of the dashboard to run it.
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 Calculation.
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 Calculation.
The selected metric is displayed by default as the first metric in the calculation, but you can change it. From the first drop-down list, select another metric, or type a number in the field.
Click the arithmetic operator to use to combine the metrics.
From the next drop-down list, select the second metric to use in the calculation, or type a number in the field.
Click OK. The new metric is added to the dashboard.
To create a new metric by combining the values of multiple metrics:
Click the name of the dashboard to run it.
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, press CTRL and click the metrics to use to create the derived metric.
To create the metric and add it immediately to a specific visualization, from the visualization’s Editor panel, press CTRL and click the metrics to use to create the derived metric.
Right-click the selected metrics, point to Calculation, and then select the function to use to combine the metrics. The options are:
To add the metrics together, select Add.
To calculate the average of the selected metrics, select Average.
To calculate the maximum across each of the selected metrics, select Greatest.
To calculate the minimum across each of the selected metrics, select Least.
To calculate the product of the selected metrics, select Multiply.
The following options are available if you have selected two metrics:
To divide the first metric that you selected by the second, select Metric1/Metric2.
To divide the second metric that you selected by the first, select Metric2/Metric1.
To subtract the second metric that you selected from the first, select Metric1-Metric2.
To subtract the first metric that you selected from the second, select Metric2-Metric1.
To calculate the difference between the metrics as a percentage of the second metric that you selected, select (Metric1-Metric2)/Metric2.
To calculate the difference between the metrics as a percentage of the first metric that you selected, select (Metric2-Metric1)/Metric1.
The metric is created and added to the dashboard.
Creating a metric based on existing objects: Derived metrics
Editing or deleting derived metrics in a dashboard
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices