Reports: Adding metrics to a report

Metrics are MicroStrategy objects that represent business measures and key performance indicators. From a practical perspective, metrics are the calculations performed on data stored in your database, the results of which are displayed on a report. For details on metrics, see Calculating data on a report: Metrics.

To add a metric to a report

If you are using one of your organization's projects, this procedure assumes at least one metric has been created. If you need to create metrics, see Calculating data on a report: Metrics.

1. In MicroStrategy Web, create a new report in Design Mode. See Creating a report with the Report Editor.

2. In the All Objects pane on the left, navigate to your project's metric folder and open it.

   • If you are using the Tutorial project, open the Public Objects folder, then open the Metrics folder. Select any metric to use in the next step. In this procedure, the Average Revenue metric from the Sales Metrics folder is used.
   • To search for a metric in your project, type the name of the metric in the Find text field and press Enter or click the Find icon.

3. To add a metric to the report, do one of the following:

   • Drag and drop the metric to the desired location on the report's grid.
   • Double-click the metric to add it to the report.
   • Right-click the metric and select Add to Grid as shown in the image below, then move it to the desired location on the report's grid.

   

   Metrics are commonly displayed in a report's columns, although you can add metrics to a report's row, if you want. To add a metric to a row, do one of the following:

   • Drag and drop the metric on the row in the report grid.
   • Right-click the Metrics header, select Move and select To Rows.

4. The metric appears in the row or the column section of your report's template depending upon where it is added, as shown in the image below:

   

5. Repeat the steps above to add additional metrics to your report, as needed.

6. Almost all reports have one or more attributes, one or more metrics, and one filter. If you need to, use the following sections of this manual to add additional objects to your new report:

   • Attributes: Reports: Adding attributes to a report.
   • Filters: Reports: Adding a filter to a report.
   • Prompts: Reports: Adding prompts to a report, metric, or filter.
7. If you want to see what your report looks like when executed against the data source, once your report has one or more attributes and metrics in it, from the toolbar select Run Report.
8. Save the report.