Bar chart in a grid

A bar chart used in a Grid widget can display values of one or two numerical measures.

You can edit the columns and appearance of the bar chart.

In the Grid panel, move the mouse pointer to the a bar chart column, click the administration Setup icon to specify the measures to display, or click the view Appearance icon to set the chart layout.

The following setup options are available.

Options

Description

Setup

Columns

Measures displayed in the chart of the selected bar chart column.

To change the display name of a measure, move the mouse pointer to a measure and click edit Edit.

Add secondary measure

Adds a second measure to the bar chart. Select a measure in the drop-down menu.

Appearance

Display name

Name of the criteria displayed as a tooltip in the chart.

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.

Number formatting

Enables the formatting of the measure values. Click edit Edit.

  • 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.

Data range

Allows you to specify a range for the measure values to be displayed for numeric data columns.

Click edit Edit > Enter Input constant values to specify the From and To range limits.

If you specify a data range, the cells outside the range are displayed with a fully saturated color.

Show cell values

Displays the measure values in each table cell with a bar chart.

Colors

Colors of the measures displayed in the chart. To change a color, click edit Edit and select a color. You can select a predefined or specify custom color for each measure.