Advanced Thresholds Editor

The Advanced Thresholds Editor displays a list of all thresholds currently defined for the visualization. Use thresholds to format data in a visualization based on multiple attribute or metric qualifications.

Pre-requisites:

Your dossier must contain a grid visualization. You can only use the Advanced Thresholds Editor for grid visualizations.

You have placed a metric in the Metrics area or an attribute in the Rows or Columns area.

Access

To access the Advanced Thresholds Editor:

In the Editor panel, right-click an attribute or metric and choose Thresholds. If you select an attribute, the Advanced Thresholds Editor opens. If you select a metric, the Quick Thresholds Editor opens.

If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor.

Fields

New Threshold: Select this link to add a new threshold.

Order: Displays the order in which the system evaluates a threshold. Click and drag a threshold to reorder it.

Threshold Conditions: Displays the threshold conditions. Select a threshold condition to edit its corresponding metrics, attributes, filter options, qualifications, operators, elements, or values.

Add Condition: Select this link to add a new condition.

Group Conditions: Select this link to group conditions together. A threshold must contain multiple conditions for this link to appear.

Operator: Select the drop-down between conditions and choose an operator for combining conditions (for example, AND, OR, AND NOT, and OR NOT). A threshold must contain multiple conditions for this drop-down to appear.

Format Preview: Displays a preview for displaying data that meets the threshold's condition. Click on the preview to select formatting options for the condition. Click More to perform the following actions:

Apply to: Select whether to apply the condition to Metrics Only, Subtotals Only, or Metrics and Subtotals that meet the threshold conditions.

Formatting: Allows you to select the following formatting options for the condition:

Replace Data: Select the Enable Data Replace checkbox to replace the data that meets the threshold condition with the options in the corresponding drop-downs.
Font: Select font formatting options.
Color and Border: Select fill color and border options.

Duplicate: Adds a copy of the current condition to the end of the list.

Move Up/Move Down: Change the order in which the system evaluates a condition by moving it up or down in the list.

New Condition: Add a new condition to the end of the list.

Quick Thresholds Editor: Select this link to open the Quick Thresholds Editor.