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.