MicroStrategy ONE
Filtering metrics on rank and percentage ranges
In addition to restricting report results based on qualifications of metrics, you can also restrict report results based on the rank or percentage range of a metric value for a given report. This enables you to display reports with data such as products in the top 40% of profitability. You could also create a report to return the top 10 employees in terms of average performance score.
It is important to understand the operators that are available for these types of view filters. When creating view filter qualifications on the rank or percentage ranges of metric values, you can use the following mathematical and logical operators, which are described as they relate to rank and percent metric qualifications in the table below:
You can also create a new view filter qualification on a metric by right-clicking a metric and pointing to Filter On. For more information, see Filter on Metric dialog box.
Operator |
Functionality and considerations |
Exactly |
Identifies a specific value, as described below:
|
Different from |
Identifies values that are other than the specific value indicated:
|
Between |
Identifies values in a range that has both a lower and an upper limit:
|
Not Between |
Identifies values in a range that has both a lower and an upper limit. Data is restricted for any values outside of this range:
|
Is Null |
Identifies values that are null. Using the rank or percent metric qualifications is not necessary with this operator. To return all data where metric values are Null, you can simply create a view filter metric qualification on the metric that uses the Is Null function. |
Is Not Null |
Identifies values that are not null. Using the rank or percent metric qualifications is not necessary with this operator. To return all data where metric values are not null, you can simply create a view filter metric qualification on the metric that uses the Is Not Null function. |
Top |
Identifies the topmost value range in a given set:
|
Bottom |
Identifies the lowest set of values in a given set:
|
Exclude top |
Identifies a value range that is not in the topmost value range in a given set:
|
Exclude bottom |
Identifies a value range that is not in the lowest set of values in a given set:
|
Is Highest |
Identifies the highest value. This operator should only be used with rank ranges. For rank ranges, this restricts report results to display data for only the highest value of a given metric. |
Is Lowest |
Identifies the lowest value. This operator should only be used with rank ranges. For rank ranges, this restricts report results to display data for only the lowest value of a given metric. |
The rank and percentage ranges view filters are discussed in the sections listed below:
-
Creating view filters on a rank range of metric values: You can create a view filter that restricts report results based on a rank range of metric values for a given report. This can allow you to view analysis such as the bottom 20 products in terms of profit margin.
-
Creating view filters on a percentage range of metric values: You can create a view filter that restricts report results based on a percent range of metric values for a given report. This can allow you to view analysis such as employees between 30% and 60% of tenure length with the company.