You can specify thresholds for numeric and text measures to display their status. A threshold limits a value range upwards or downwards. Using rules, you can define colored value ranges that indicate the status of a measure value.
You can color different elements in a chart based on defined threshold values. Depending on the chart type, you can color the chart background, an additional line, or the data points displayed in the chart.
Background coloring
You can colorize the chart background based on thresholds. Each rule defines a range along the numeric axis and a color.
Threshold line coloring
You can display a colorized line based on thresholds. Each rule defines a border on the numeric axis and a color. You can also display the data point labels in the same color as the data points.
Line thresholds can be visualized on the following chart types: Line, Area, Column, Bar, Combined, Waterfall, Bubble, and Polar charts. For Polar chart however, the line is displayed as a circle where the radius equals the threshold value.
Data point coloring
You can colorize the chart data points based on thresholds. Each rule defines a numeric range and a color. A rule is based on a numeric constant or a data column containing a numeric value. If a data point matches a rule the corresponding color is applied.
Rating
You can colorize the chart data points based on rating rules. Each rule defines a number of data points and a color. A rule can be defined for the good values (top) and the poor values (bottom).
Mapping
??????????????????????? Please explain.
Prerequisites
You have already assigned a data source to the widget.
Procedure
Click a widget on the dashboard. The Setup panel of the widget is displayed.
Click the ... icon in the widget panel -> Thresholds.
Define threshold for the background coloring.
Click + Add rule below Background coloring. The corresponding panel opens.
Select a condition in the corresponding drop-down menu, for example, less than (<).
Specify a value for the threshold. You can enter a constant value (default) or select a specific column to specify the threshold. Click
>
Select column and select a column.
To specify the color for the value range, click the color box, and select a predefined color, or specify an individual color on the Custom tab.
Click + Add rule to define more thresholds.
Click Done.
To edit a specified threshold definition, click the corresponding Edit icon.
You specified thresholds for the background coloring.
Define threshold for the line coloring.
Click + Add rule below Threshold line coloring. The corresponding panel opens.
Select a condition in the corresponding drop-down menu, for example, less than (<).
Specify a value for the threshold. You can enter a constant value (default) or select a specific column to specify the threshold. Click
>
Select column and select a column.
To specify the color for the value range, click the color box, and select a predefined color, or specify an individual color on the Custom tab.
Click + Add rule to define more thresholds.
Click Done.
To edit a specified threshold definition, click the corresponding Edit icon.
You specified thresholds for the threshold line coloring.
Define threshold for the data point coloring.
Click + Add rule below Data point coloring. The corresponding panel opens.
Select a condition in the corresponding drop-down menu, for example, less than (<).
Specify a value for the threshold. You can enter a constant value (default) or select a specific column to specify the threshold. Click
>
Select column and select a column.
To specify the color for the value range, click the color box, and select a predefined color, or specify an individual color on the Custom tab.
Click + Add rule to define more thresholds.
To colorize the axis labels, enable the corresponding option. The axis labels are colorized in the same color as the data points.
Click Done.
To edit a specified threshold definition, click the corresponding Edit icon.
You specified thresholds for the data point coloring.
Define threshold for the Rating coloring.
Click + Add rule below Rating. The corresponding panel opens.
Specify a condition in the corresponding drop-down menu. For example, to colorize the top five data points, select Top in the drop-down menu and enter 5 as value.
To specify the color for the data points, click the color box, and select a predefined color, or specify an individual color on the Custom tab.
Click + Add rule to define more thresholds.
You can also colorize the remaining data points. Below Colorize remaining, enable the Colorize option and select a color in the corresponding Color box.
Use percentage values, ????????????????? Please explain.
To colorize the axis labels, enable the corresponding option. The axis labels are colorized in the same color as the data points
Click Done.
To edit a specified threshold definition, click the corresponding Edit icon.
You specified thresholds for the data point rating.
You specified thresholds for the widget.
Example
In this example, three ranges of values were defined with two thresholds at 100 ms and 350 ms.