MicroStrategy ONE
Filter on Metric dialog box
A view filter restricts the amount of data displayed on the report and provides you with a different view of the data. You must own the OLAP Services product to create a view filter. For more details, see About view filters.
Use the Filter on Metric dialog box to create a view filter on a selected metric based on a rank range of metric values or to define a condition that is based on any metric on your report. For example, a view filter on a rank range of metric values allows you to view analysis for the bottom 20 products in terms of profit margin. A view filter based on a condition allows you to view analysis such as employees with 10-20 years of tenure with the company.
-
For steps to create a view filter on a metric based on rank, see Creating a view filter on a rank range of metric values.
-
For steps to create a view filter on a metric based on a condition, see Creating a view filter on a percentage range of metric values.
This topic provides the steps to access the Filter on Metric dialog box and explains each option in the Filter on right-click menu. The options in the Filter on right-click menu are Clear, Top N, Add Condition, and Edit Condition. This topic does not provide steps to create a certain type of view filter.
Accessing the Filter on Metric dialog box
-
Run the report in Grid View.
-
Right-click a metric on the report, select Filter On, and then select one of the following:
-
To create a view filter based on a rank range of metric values, select Top N.
-
To create a view filter based on a condition, select Add Condition.
-
The Filter On Metric dialog box opens.
-
Filter On options
When you right-click a metric and select Filter On, the menu displays different options depending on whether the selected metric already has a view filter or not. If the selected metric has prior filtering conditions applied on it, the following options are displayed:
-
Clear: Clears the existing filtering conditions for the selected metric.
-
Top N: Allows you to create a new view filter by defining a rank based on the selected metric. For steps, see Creating a view filter on a rank range of metric values.
-
Edit Condition: Displays the existing view filter condition and allows you to change the condition or add a new filtering condition.
-
Add Condition: Allows you to create a new view filter by defining a condition based on the selected metric. For steps, see Creating a view filter on a percentage range of metric values.