Grid (new editor)

You can use the Grid widget to insert a table in your dashboard.

The grid allows you also to display certain chart types into table cells. For this purpose, the grid provides appropriate column types. You find the available options of the Micro chart and Bar chart widgets in the corresponding chapters.

Example

Grid

Setup options

Data assignment

You can assign any dimension or measure to the grid widget. For each criterion, a new column is added to the table.

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.

Use column grouping

Allows you to group multiple columns. The option is disabled by default. Enable the option to group the assigned grid columns. For details, see the Group columns chapter.

Grid columns

Displays the dimension and measures assigned to the widget.

+ Add columns

Adds columns to the grid and provides appropriate column types for charts and standard columns. Select a column type in the drop-down menu.

Standard column: Suitable for characters, such as text, date, and numbers. All available columns are selectable and can be added to the grid.

Bar chart column: Suitable for bar charts. Only numerical columns are selectable and can be added to the grid.

Micro chart column: Suitable for micro charts. Only numerical columns are selectable and can be added to the grid.

Hidden columns

Displays the list of hidden columns added to the widget. They are not displayed in the widget but can be used, for example, for filtering the widget. Click + Add dimension or measure to add a hidden column. For numerical measures, AVG (average) is preset as default aggregation method. Click the More icon to select an aggregation method.

Multiple selection

Enables the multiple selection for the widget.

In view mode, the user can select multiple values at the same time in the corresponding widget, for example, multiple rows in a table or multiple coordinates in a chart. The multiple selection can be used, for example, to filter other dashboard widgets. See Use interactive filters in dashboards for details. The values selected are processed as a list. If the option is enabled, columns of List type are provided in the filter configuration dialog to configure filter conditions. See Define filters for dashboard widgets for details.

Cell selection

Enables the cell selection for the widget.

It allows you to select individual cell values in the grid (By default, the entire rows are selected).

If this option and multiple selection are enabled, you can select multiple cell values within the grid.

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 Grid widget.

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

Move the mouse pointer to a chart column and click the administration Setup icon. You find the available options of the Micro chart and Bar chart widgets in the corresponding chapters.

The options provided depend on the data type of the assigned column.

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.

Show cell value

This option allows you to show or hide the criterion values in the grid. The option is enabled by default. If you disable the option, a user will not be able to see the cell values below the criterion.

Make clickable (for actions)

Turns criterion values into clickable links that the user can use when setting up the action.

Set as key column for selection

Sets the selected column as a key column.

When a selection is made and new data arrives, the selection is automatically recreated with the new data. The key column is used to ensure that the new data matches the selection. This means that if values in non-key columns have changed, the selected row will remain selected even after new data arrives.

You can select one or more columns as key columns.

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.

Total aggregation (Configure average)

Show

Adds a separate cell below the column that displays the aggregation over the column.

Enable the option an select an aggregation type in the drop-down menu. The option is disabled by default.

Enter an optional label and select a color.

Appearance

Widget appearance

You can configure the appearance of the Grid widget by default in the view Appearance panel.

For chart columns, move the mouse pointer to a chart column and click the view Appearance icon.

The following appearance options are available.

Appearance options

Description

Pinned columns

You can pin columns in a table so that they are permanently displayed. Pinned columns are always visible, even if you scroll the table horizontally. Columns can be pinned to either the left or right side.

Select the table side (left or right) and the number of columns to pin. By default, no column is pinned.

Auto column width

Adjusts the column width automatically. The option is enabled by default.

Show thresholds in tooltip

Displays specified thresholds in the tooltip.

Enable data download

Allows downloading the source data of the widget in view mode.

In view mode, click the navigation icon in the chart > Download data.