KPI

The KPI widget displays the value of an aggregated numeric measure.

Setup options

Data assignment

You can assign a numeric measure to the KPI 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.

Measure

Displays the measure assigned to the widget. Click + Add measure and select a measure. AVG (average) is preset as default aggregation method. Click the More icon and select an aggregation method.

Auto-refresh data

Enables automatic data retrieval for the widget.

Edit the measure

You can edit the column assigned to the widget. Move the mouse pointer over the measure and click Edit Edit.

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.

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

Show icon

Displays an icon next to the measure value.

Shape

Shape of the icon. Click the icon box and select an icon.

Color

Specifies the color of the measure bar. Click the color box and select a predefined color or specify an individual color on the Custom tab.

Title

Widget title displayed below the measure value. Enter an optional title. Click the color box and select a predefined color or specify an individual color on the Custom tab.

Style

Specifies the widget style, from small to extra large. Select a style in the drop-down menu. Click the color box and select a predefined color or specify an individual color on the Custom tab.