MicroStrategy ONE
Advanced Thresholds Editor
If you arrived here from Workstation, see the Workstation Document Authoring Help.
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.
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.
Related Topics
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
Add Multiple Conditions to a Threshold 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