Version 2021
Report Limit Editor: Report Limit Qualification
When you double-click in the Limit definition area, the Report Limit Qualification pane appears at the bottom of the Limit definition area. This pane contains the following options:
-
Metric: Drag, type, or browse for the metric on which to qualify.
Derived metrics cannot be used in a report limit. A report limit is a SQL engine function and therefore can only use a metric that exists in the project. A derived metric, which is created within the report, exists only in the report. To use the derived metric, re-create it as a regular metric, using the Metric Editor.
-
Function: Choose from the following:
-
Metric Value: The value on which to qualify the metric. For example, a metric value greater than or equal to 10 returns all values for that metric that are 10 or higher.
-
Rank: The numeric rank of values. For example, rank top 40 returns the 40 highest values for the selected metric.
-
Percent: Percentage of the values being ranked. For example, percent top 10 returns all values in the top 10% for the selected metric.
-
Operator: Select the desired comparison operator from the drop-down list.
-
Value (in drop-down box): Select to enter a numerical value.
-
SimplePrompt (in drop-down list): Select to enter a simple value prompt that the user answers at run time.
-
Metric (in drop-down box): Select to type, drag, or browse for a metric.
-
Custom (in drop-down box): Select to enter filter, metric-to-metric, or metric-to-attribute form comparisons.
-
-
Prompt: Select to open the Prompt Generation Wizard. The Prompt Generation Wizard assists you in creating prompts.
-
BreakBy: Click to open the Breakby tab of the Level dialog box, which allows you to set the break by for a metric's rank operator. Break By is enabled only if you choose Rank or Percent from the Function list. See Level dialog box for more information.
-
Advanced: Click Advanced to access the Advanced Options box, in which you can specify whether existing attribute qualifications should be merged into the calculation when this filter is evaluated.