Configure thresholds

You can define thresholds for numeric and text columns to display the status of a KPI. A colored marker shows the threshold range in which a KPI value is located.

By default, there are three traffic light stages plus the inactive stage.

Procedure

  1. Click Thresholds.

    The option is only available if a column has been assigned to the KPI.

  2. Select Color and shape in the drop-down menu to display the traffic light stages with various colored shapes.
  3. Click a color box to select a color and a shape for each threshold stage.
  4. Select Image in the drop-down menu to use custom images instead of the colored shapes for each traffic light stage.
  5. Select an operator for each threshold to define the KPI value range, for example, < (less than).

    The available operators differ for numeric values (for example, < (less than) or = (equals to)) and text columns (for example, starts with or is equal to).

  6. Enter a value for each threshold.

    You can either enter specific threshold values or you can choose columns from your data source representing dynamic threshold values. Only numeric data columns are allowed for dynamic threshold values. Assign the required numeric data column from the data source to a threshold field using drag and drop.

  7. Click the Add Plus button to add a threshold or the Remove Minus button to remove a threshold.
  8. By default, the traffic light stage is also visible if it is inactive (A KPI value is not available.). Disable the Inactive state option if the traffic light stage should not be visible. You can also change the color of the inactive traffic light stage. If you use custom images, you cannot change the color. You can only deactivate the Show inactive state option.

The thresholds are configured for the selected widget.