MicroStrategy ONE

Create 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 for a grid visualization.

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.

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

Related Topics

Introduction to Thresholds

Create a Threshold on a Metric Using the Quick 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

Remove All Thresholds Defined on an Attribute or Metric