Derived Metrics

Derived metrics are based on existing metrics on a report. A derived metric performs a calculation on the fly with the data available on a report, without re-executing the report against the data source. These metrics can be saved and displayed only on the specific report on which they are created.

Metrics must already exist in a report to create a derived metric. If the derived metric requires data not available on the report or in the Report Objects panel, the report must be re-executed against your data source before the new data is displayed.

You must have the necessary privileges to add or remove metrics and calculations.

To create a derived metric on a report

Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.
From the Data menu, select Insert New Metric. The Insert New Metric dialog box opens.
Select New metric in the Object drop-down list.
In the Name field, enter the name of the new metric.
In the Definition field, enter the formula to designate how the metric should be calculated. Use the right arrow button to move metrics from the Available box to the Definition box. Enter arithmetic operators between metrics. For example, [Revenue]/[Profit].
- When using another metric with spaces or special characters in its name, place the name within brackets [ ]. For example, [$ Sales].
- You may use arithmetic operators and parentheses in the formula. For example, the formula for a derived metric called Profit may be [$ Sales] - Cost
To create a more advanced derived metric, for example, Running Sum of Revenue or Average of Daily Website Hit Counts, you can define the metric based on a function. To access a list of functions you can use, click the Function Wizard icon before adding anything to the Definition pane. For steps to use functions to insert new metrics, refer to Creating a derived metric using a function.
Click OK to create the new metric.