MicroStrategy ONE

Quick Thresholds Editor

Use the Quick Thresholds Editor to apply specific formatting to data that meets certain conditions. This formatting is called a threshold.

A grid visualization displays revenue data for different geographical regions. You can use thresholds to display revenue values less than $500,000 in red, or replace values greater than $5,000,000 with a company logo.

Your dossier must contain one of the following:

  • A grid visualization with a metric in the Metrics area of the Editor panel.
  • A network visualization with a metric in the Edge Color area of the Editor panel.
  • A graph, heat map, or map visualization with a metric in the Color By area of the Editor panel.

Access

To access the Quick Thresholds Editor:

  1. Click on the visualization to which you want to add a threshold.
  2. In the Editor panel, right-click the metric to define a threshold on and choose Thresholds. This is the same metric defined in the Prerequisite section above.

Fields

Thresholds Type: Select the Color-based radio button to create a threshold that changes the color used to display metric values. Select the Image-based radio button to create a threshold that replaces metric values with an image. This option only appears if your visualization supports replacing metric values with images.

Color: Select a color scheme to apply to the metric values. Click Reversed to reverse the order of the colors displaying data within the range.

Images: Select an image scheme to apply to the metric values. Click Reversed to reverse the order of images displaying data within the range.

Based on: Select one of the following metrics to determine the threshold condition:

  • Value: Creates a threshold based on the value of the metric.
  • Lowest: Creates a threshold based on the bottom n metric values.
  • Highest: Creates a threshold based on the top n metric values.
  • Lowest %: Creates a threshold based on the bottom n percent of metric values.
  • Highest %: Creates a threshold based on the top n percent of metric values.

Break By: The attribute level at which to restart counting rank or percent values for the metric. To continue counting without restarting, select None. This option is only available for thresholds that are based on rank or percent values.

Threshold Slider: Each band that appears in the threshold slider represents a different range of metric values. The color or image that appears above the band represents the formatting for displaying values that fall within its range.

You can modify the range covered by a band:

  • To increase or decrease the range of values covered by the band, click and drag a thumb left or right along the slider.
  • To change the end of a band to a specific value, double-click the thumb at the end of the band, then type the value and press the Enter key.

You can add or edit bands for thresholds that use colors rather than images:

  • To change the color applied to the range of values covered by a band, double-click the band, then select the new color from the palette.
  • To create a new band, hover over an empty section below one of the threshold bands, so that a plus appears next to the cursor. Click the band to divide it into two separate bands. You can change the range of the band, as described above.
  • To delete a band, click the band and press the Delete key.
  • To delete a thumb, click the thumb and press the Delete key.

Related Topics

Create a Threshold on a Metric Using the Quick Thresholds Editor