MicroStrategy ONE

Introduction to Thresholds

You can highlight metric data in a visualization by applying formatting to the visualization when data fulfills a specific condition. This formatting is called a threshold.

A grid visualization can display revenue for different geographical regions. You can display revenue values less than $500,000 in red, values greater than $5,000,000 with a company logo, or highlight the names of regions with revenue values less $500,000.

If a grid visualization displays a server status, you can display the names of servers that are down in red.

Thresholds can make analyzing large amounts of data easier because images are easy to locate and different colors are quickly identified.

A threshold is made up of two parts: the condition and the formatting you apply to the values that meet the condition. Conditions can vary in complexity depending upon the type of threshold that is created. The data that meets the condition passes the threshold of the condition.

An example of a condition could be revenue values less than $500,000 or a server status of down. Once a metric value or an attribute element meets the threshold condition, the formatting automatically applies to the value or element.

You can apply thresholds to:

  • Map visualizations that display map markers. You can customize the colors used to display map markers or replace image markers with a different image, based on the value of a metric.
  • Map visualizations that display areas. The map areas appear in different colors based on the value of a metric.
  • Graph visualizations. You can customize the colors of objects (for example, bar, lines, etc.) based on metric values or attribute elements.
  • Grid visualizations. You can apply threshold formatting to metric values or attribute elements.
  • Heat map visualizations. The rectangles of the visualization are automatically colored based on the value of a metric.
  • Network visualizations. Edges in the visualization are automatically colored based on the value of a metric.

When you create a threshold on a metric, you can apply the threshold formatting to:

  • The values of the metric
  • The subtotals of the metric
  • Both the values and subtotals of the metric

When you create a threshold on an attribute, you can apply the threshold formatting to:

  • The attribute elements
  • Metric values
  • Attribute elements and metric values (for example, the entire row of a grid)

Related Topics

Format Dashboards and Visualizations

Introduction to Thresholds

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

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