Micro chart in a grid

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

You can edit the columns and appearance of the micro chart. In the Grid panel, move the mouse pointer to the a micro 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 options are available.

Options

Description

Setup

Columns

Measures displayed in the micro chart.

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

Add measure

Adds a measure to the micro chart. Select a measure in the list.

Appearance

Chart type

Chart type of the micro chart. The micro chart can be displayed as line, area, and column chart. Select a chart type.

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.

They are displayed in the tooltip.

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

Y-axis range per chart

Calculates the minimum and maximum values separately for each chart instead of using the minimum and maximum values of an entire column by default.

Highlight information

Highlights specific data points, such as the first and last measure value (First last), the best and worst values (Top flop), or only the last value (Last). Select the highlighted data in the drop-down menu.

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.