You can use the Grid widget to insert a table in your dashboard.
The widget is available only for the new dashboard editor.
Example
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.
Example
The following setup options are available.
Setup options |
Description |
---|---|
Data source |
Displays the columns of the assigned data source. Click |
Grid columns |
Displays the dimension and measures assigned to widget. Click + Add dimension or measure and select a criterion. |
Group columns |
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. |
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. AVG (average) is preset as default aggregation method. Click the |
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 the automatic data retrieval of the widget. |
Edit a dimension, measure, or hidden column
You can edit the columns assigned to the widget. Move the mouse pointer over a dimension,
measure, or hidden column and click Edit.
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. |
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 |
Allows 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. Default is Auto. |
Precision |
Allows to select the decimal fraction in the drop-down menu. Default is Auto. |
Enable Prefix/Suffix |
Allows to specify a prefix and suffix.
|
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 |
---|---|
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. |