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.

Related Topics