You can define thresholds for numeric and text grid columns to display the status of a KPI. A colored marker shows the threshold range in which a KPI value is located.
Procedure
Click an assigned Grid columns to specify the settings.
Click the Thresholds tab.
Click Background or Foreground to set the KPI values and the background or foreground colors of the grid.
You can define a KPI value range for the thresholds and the corresponding colors of the grid cells background or foreground.
Click a Color box to select a color for each threshold.
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).
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 text data columns are allowed for dynamic threshold values. Assign the required text data column from the data source to a threshold field using drag and drop.
Click the Plus button to add a threshold or the Minus button to remove a threshold.
Enable the Colorize row option to apply the background or foreground color scheme to all cells in the row.
Click Traffic Lights to set KPI values and to define traffic lights.
You can define a KPI value range for the thresholds and corresponding traffic lights. The traffic lights are displayed in each cell of the rows. By default, there are three traffic light stages and one inactive stage. Additionally, you can select a different shape for each traffic light stage.
Click a Color box to select a color and a shape for each traffic light stage.
To use custom images instead of the colored shapes for the traffic light stages, enable the Image based Traffic Light option, click the drop-down menu and enter an Image URL.
Enable the Multi State option to show multiple states of traffic lights instead of a single traffic light.
Select an operator for each threshold to define the KPI value range, for example, is equal to.
Enter a value for each threshold.
You can either enter specific threshold values or you can choose numeric columns from your data source representing the threshold values. Assign a data column from the data source to a threshold field using drag and drop.
Click the Plus button to add a traffic light stage or click the Minus button to remove a stage.
Enable the Switch position option to place the traffic light symbol to the right of the values.
Enable the Make clickable (for actions) option to make the traffic lights clickable for triggering actions. See Specify actions for widgets for details.
Enable the Show tooltip option to show tool tips for each traffic light symbol.
By default, the traffic light stage is also visible if it is inactive (that is, 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.
Click OK.
The thresholds are configured for the selected widget.