Creating a Derived Metric Using a Function

When you create a derived metric, you can define it using a function, which allows you to create a more complex derived metric. For example, you can choose a RunningSum function to create a RunningSum of Revenue (RunningSum(Revenue)) metric.

To create a derived metric using a function, you select the function, define its arguments and parameters, and then specify the metrics on which to base the new metric.

The steps below show you how to create a derived metric in a report. You must have the necessary privileges to add or remove metrics and calculations.

To create a derived metric using a function:

Run a report in either Grid view or Grid and Graph view.
From the Data menu, select Insert New Metric. This displays the Insert New Metric dialog box.
In the Definition field, enter the formula that should appear before the function, if any.
Click the Function Wizard icon . This displays the Insert Function dialog.
From the Select a category drop-down list, select the function to use. When you select a folder, the list of functions in that folder are displayed in the Select a function area. A description of each function is displayed below the area.
Click OK. The Function Arguments dialog box opens.

Define the function by entering values for each parameter. The arguments and parameter options that appear differ depending on the function you chose.