MicroStrategy ONE
How to Filter 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.
You need the Web Use View Filter Editor privilege.
To create a view filter with a metric-to-metric qualification
- Log into a project in MicroStrategy Web.
- Run the report in Grid View.
- If the View Filter area is not displayed, from the Tools menu, select View Filter.
- In Web, in the View Filter area, click Add Condition.
- From the Filter On drop-down list, select a metric.
- Select an operator from the drop-down list and type a value.
- To compare the metric to another metric, click the Select Metric icon . Then select another metric to compare it to.
- Click Apply icon to complete the view filter qualification.
- If the Auto-Apply Changes checkbox is cleared, click Apply to apply the view filter to the report.