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:

  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.

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