Settings pane

Use this pane to set the thresholds that are to be displayed in a funnel graph or gauge.

Each threshold has a high and a low 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.

For more information, see:

This pane is part of the "Results tab: Funnel editor" and the "Results tab: Gauge editor".

Components

High values are desirable

Use this box to specify whether the high values are the desirable goal. Selecting this box lists the statuses in order from the most desirable indicator (for example, Excellent) at the top to the least desirable indicator (for example, Warning) at the bottom.

Low values are desirable

Use this box to specify whether the low values are the desirable goal. Selecting this box lists the statuses in order from the least desirable indicator (for example, Warning) at the top to the most desirable indicator (for example, Excellent) at the bottom.

Threshold

Use this list to specify the data values in a gauge that highlight a particular range of values. The values must be between the minimum and the maximum values set for the gauge limits. The range identified by a threshold is filled with a color that is different from the color of other ranges.

To specify a data value, you can either:

Enter a static value directly in a Threshold field.
Click the Threshold Options button to set the value based on a measure column, a variable expression, or the results of a SQL query.

Threshold Options

Displays these options to set a threshold:

Measure column — Use this option to use the measure column.
Dynamic — Use this option to let the system determine the threshold value.
Custom Value — Use this option to enter a specific value.

If you select this option and then:
- Click elsewhere on the pane without entering a value, the value of the Threshold field reverts to the previous value
- Enter an invalid value in Threshold field, the value is cleared so that you can enter a new value
Variable Expression — Use this option to display the "Enter Expression dialog", where you specify a variable expression.
SQL Query — Use this option to display the "Enter Expression dialog", where you specify a SQL query.
Remove — Use this option to remove the threshold.
Add Above — Use this option to add a threshold row above the current row.
Add Below — Use this option to add a threshold row below the current row.

Status

Use this list to specify the label for each range identified by a threshold and the color in which the range is to be displayed in the gauge. Use the Status Options button to specify a label and the Color button to specify a color for each range.

Status Options

Displays the following options:

Threshold Values — Use this option to use the current threshold values as the label for the range. The Status box is disabled when you select this option.
Specify Label — Use this option use text that you specify as the label for the range, for example Excellent. After selecting this option, enter the text in the Status box.

Color

Displays the Color Selector dialog, where you select the color for the range that is identified by the threshold.

First Stage x final stage target value

This field is available only for last-stage only funnel graphs.

Use this box to enter the factor required to meet the target. In a last-stage only funnel graph, the target value of all the stages before the last are calculated based on the last stage target value and this target factor.

Add Threshold

Use this button to add a new threshold row.

Delete Threshold

Use this button to delete a threshold row.