Set Thresholds

You can set thresholds for display in gauges and funnel graphs.

Each threshold has a high and a low value and is associated with a color in which the range identified by the threshold is displayed in the gauge, such as green for acceptable, yellow for warning, and red for critical.

1. Click Edit View to display the view editor.
2. In the Settings pane, select either High values are desirable or Low values are desirable.

   For example, selecting High values are desirable lists the statuses in order from the most desirable indicator (such as Excellent) at the top to the least desirable indicator (such as Warning) at the bottom. Generally with columns such as Revenue, high values are desirable. With columns such as Expenses, low values are desirable.

3. In the Threshold list, specify the data values that highlight a particular range of values.

   The values must be between the minimum and maximum values set for the view's limits. The range that a threshold identifies is filled with a color that differs from the color of other ranges.

   To specify a data value, you can enter a static value directly in a Threshold field, or you can click Threshold Options to set the value based on a measure column, a variable expression, or the results of a SQL query. Select Dynamic to enable the system to determine the threshold value.

4. Enter the labels for the ranges in the Status area.
   • Select Threshold Values to use the current threshold values as the label for the range.
   • Select Specify Label to use text that you specify as the label for the range, such as Excellent.