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:
On the project's main page, click
Create Filter. The New Filter
page opens. Or, from the Admin menu, choose Filter. From the Filters
page, click the Create Filter
icon.
In the pane on the left, navigate to the first metric to use in the metric comparison.
Right-click the metric and select Add to Filter.
From the next drop-down list, select the operator that describes how you want to filter data, such as Equals or Less Than.
Click the Select
Metric icon . The
Select an Object dialog box is displayed.
Navigate to and select the second metric to use in the comparison.
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.
Click Apply to create your filtering condition.
Click Save As. The Save As dialog box opens.
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.
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices