Traffic lights

A multi-color vertical, horizontal, or single traffic light shows the threshold range in which a value is located.

Setup options

Data assignment

You can assign any dimension or measure to the Traffic light widget.

The following setup options are available.

Setup options

Description

Data source

Displays the columns of the assigned data source. Click Edit Edit to open the data source settings in the data feed editor. Click Delete Delete to remove the assigned data source.

Traffic light

Displays the dimension or measure assigned to the widget.

Click + Add dimension or measure and select a criterion.

Auto-refresh data

Enables automatic data retrieval for the widget.

Edit a dimension, measure, or hidden column

You can edit the columns assigned to the widget.

Move the mouse pointer to a column and click the Edit Edit icon to edit, for example, the display name or format of measure values. For numerical columns, you can also select the aggregation next to the column name (Show tab bars).

The following setup options are available.

Setup options

Description

Display name

Name of the criteria displayed in the widget.

Click Revert to '...', to restores the initial display name.

Date column

Date formatting

Enables you to specify the date format.

Precision

Time unit, for example, second or hour. The default setting is Auto.

Time of day only

Displays only the time of the criterion value.

Example

If the option is enabled, the date value 23 Oct 2008 12 AM is displayed as 12 AM only.

You can enable the option if the precision is hours, minutes and seconds or if the criterion value contains time units.

Numerical form

Displays the date in numeric form.

Example

23 Oct 2008 is displayed as 23/10/2008.

The option is disabled by default. It is disabled for year and quarter precision.

Long form

Displays the full date without any short notations.

Example

23 Oct 2008 is displayed as 23 October 2008.

The option is disabled by default.

Number column

Aggregation

Aggregation type for the column values: Average, Sum, Minimum, Maximum, and Count. Default is Average (AVG). Select an aggregation type.

Treat as timespan

The column is used as timespan. The option is disabled by default. Enable the option and specify the time span settings.

Base unit

Select the base unit for the timespan, for example, seconds or minutes.

Use decimal fractions

Allows to specify the number of decimals. The option is enabled by default. Select the decimal fraction in the Precision drop-down menu. The default is Auto.

Precision

Allows to select the decimal fraction in the drop-down menu. The default is Auto.

Enable Prefix/Suffix

Allows to specify a prefix and suffix.

  • Prefix: Appends given characters at the beginning of the cell value.

  • Suffix: Appends given characters at the end of the cell value.

Thousands separator

Displays a thousands separator in the column values.

Abbreviation

Values are displayed abbreviated.

Appearance

Widget appearance

You can configure the appearance of the widget.

The following appearance options are available.

Appearance options

Description

Type

Specifies the type of the Traffic light widget, Vertical, Horizontal, or Single. Select the type in the drop-down menu.