Introduction to Derived Metrics

You can create a new metric while you are viewing a report. For example, you can subtract the values of one metric from the values of another metric, such as Revenue Forecast - Revenue. You can calculate a monthly average, for example, Yearly Profit / 12. If the report shows the dollar sales for a particular region, you can create a derived metric to view the same data in millions, defined as Dollar Sales/1,000,000.

Derived metrics are metrics that a report analyst can create based on existing metrics on the 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. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and documents. They are metrics that are saved and displayed only on the specific report on which they are created.

You can only use metrics already existing 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 can create derived metrics in reports on documents, as described below, or in the document itself, as described in the Document Creation Help.

To Create a Derived Metric on a Report

1. Click the name of a report to execute it or open the document in Design Mode or Editable Mode, then select the report in the Layout area.
2. Go to Data > Insert New Metric.
3. If DHTML is disabled, click Go.

To Define the Derived Metric

1. In the Name field, type the name of the new metric.
2. In the Definition field, type the formula to designate how the metric should be calculated. For example, type [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
   • If DHTML is enabled, you can select a metric from the Available list and add it to the Definition area.
3. 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 How to Create a Derived Metric on a Report Using a Function
4. Click OK.

Related Topics

How to Create a Derived Metric on a Report Using a Function