Filtering on metric-to-metric comparisons

You can compare values of two metrics to filter the results of a report by creating metric-to-metric qualifications. This type of metric qualification can provide analysis such as comparing metric values over time.

The steps below show you how to create a view filter with a metric-to-metric qualification, as well as how the example scenario above was created.

Prerequisite

•  

• You need the Web Use View Filter Editor privilege. This privilege is part of OLAP Services.

To create a view filter with a metric-to-metric qualification

•  

1. Log into a project in MicroStrategy Web.

2. Run the report in Grid View.

3. If the View Filter area is not displayed, from the Tools menu, select View Filter.

4. In Web, in the View Filter area, click Add Condition.

5.  From the Filter On drop-down list, select a metric.

6. Select an operator from the drop-down list and type a value.

7. To compare the metric to another metric, click the Select Metric icon . Then select another metric to compare it to.

8. Click Apply icon to complete the view filter qualification.

9. If the Auto-Apply Changes check box is cleared, click Apply to apply the view filter to the report.