MicroStrategy ONE
Add Multiple Conditions to a Threshold in the Advanced Thresholds Editor
You can add multiple conditions to a threshold in the Advanced Thresholds Editor.
Your dashboard must contain a grid visualization. You can only use the Advanced Thresholds Editor for grid visualizations.
You previously created a threshold on the Advanced Thresholds Editor.
- In the Editor panel, right-click an attribute or metric that contains a threshold 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.
- Hover over the threshold to which you want to add additional conditions and click Add Condition.
- 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.
- 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.
-
To define the condition based on attributes in or not in a checklist, select Selecting in list from the Choose elements by drop-down. 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 elements, except those you select.
- Click OK twice.
Related Topics
Create a Threshold on a Metric Using the Quick Thresholds Editor
Create a Threshold on an Attribute or Metric in the Advanced Thresholds Editor
Format a Threshold on an Attribute or Metric in the Advanced Thresholds Editor
Group and Combine Threshold Conditions in the Advanced Thresholds Editor
Edit, Duplicate, Rearrange, and Delete Thresholds in the Advanced Thresholds Editor