Metric-to-metric qualification

Using a metric-to-metric qualification allows you to filter the results of a report by comparing the values of two metrics. For example, you can return data only for retail locations whose Cost is greater than their Revenue.

The procedure below shows you how to create a stand-alone metric-to-metric qualification filter.

To filter data using a metric-to-metric qualification

1. On the project's main page, click Create Filter. The New Filter page opens.

2. In the pane on the left, navigate to the first metric to use in the metric comparison.

3. Right-click the metric and select Add to Filter.

• If DHTML is disabled, select the metric and click Add > to add the metric to the Filter panel.

4. From the next drop-down list, select the operator that describes how you want to filter data, such as Equals or Less Than.

5. Click the Select Metric icon . The Select an Object dialog box is displayed.

6. Navigate to and select the second metric to use in the comparison.

7. Click OK to return to the New Filter page. The name of the metric is displayed in the last drop-down list.

• You can select a different metric to use in the comparison by selecting New Metric from the drop-down list.

8. Click the Apply icon to create your filtering condition.

9. Click Save As. The Save As dialog box opens.

10. Navigate to the folder where you want to save the filter. Type a Name and Description for the filter, and click OK. Your new filter is saved.

The filter that you created can now be added to a report. For steps, see Adding a stand-alone filter to a report.