Creating a threshold on an attribute or metric in the Advanced Thresholds editor

You can create a threshold on an attribute or metric in the Advanced Thresholds Editor.

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.

To Create a Threshold on an Attribute or Metric in the Advanced Thresholds Editor for a Grid Visualization

1. 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.

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

3. Click New Threshold.

4. In the Based On list, select the object to base the threshold on. The condition is based on either an attribute or metric. If you are creating a condition based on a metric, go to step 5. If you are creating a condition based on an attribute, go to step 6.

5. In the Operator list, select a comparison operator (Greater Than, Less Than, etc). To compare the metric to a specific value, enter the value in the text box. To compare the metric to the value of another metric, select the metric from the Metric list. Go to step 7.

6. To define the condition based on attributes in or not in a checklist, select Selecting in list from the Choose elements by drop-own. Then, select In List or Not in List and select the attribute elements you want to use. In List formats data only for the attribute elements you select. Not in List formats data for all attribute elements, except those you select.

   or

   To define the condition based on attribute form values, select Qualification on from the Choose elements by drop-down. You can qualify the condition based on the attribute element's ID form, one of its description forms, or the DATE form if the attribute is time-based using the radio buttons. Next, select an operator from the Operator list. To compare the attribute to a specific value, enter the value in the Value field. To compare the attribute form to another attribute form, select the attribute from the Attribute drop-down. Then, select the corresponding attribute form.

7. Click OK. The Advanced Thresholds Editor opens.

8. Click More to the right of the threshold condition and choose Formatting.

   Select formatting options for displaying the threshold.

9. Click OK.

10. Click OK.