You can display micro charts and bar charts in table cells. The Grid widget provides appropriate column types for charts and both chart types are adapted for display in table cells.
Procedure
Create or open a dashboard.
Insert a grid into the dashboard or select an already inserted grid. The Grid panel to setup the grid opens.
Click + Add column and select a column type (Standard, Bar chart, or Micro chart column). Another panel opens where you can select the columns to add to the grid.
Which columns are provided depends on the type of column you selected. For a standard column, all available columns are provided (date, text, or numbers). For a bar chart and micro chart column, only numerical columns are provided.
Select the columns.
Click Done. The added columns are listed in the Grid panel. For each selected chart column, a new grid column is added, in which a corresponding chart is displayed in each cell.
You can configure the content and appearance of each column. Depending on the selected column type (chart or standard column) and column data type (date, text or numberl), different setting options are available.
You find the available options of the widgets in the corresponding chapters, Micro chart, Bar chart, and Grid.
In the Grid panel, move the mouse pointer to the column you want to configure. Different icons are displayed.
For chart columns, click the Setup icon to specify the measures to display, or click the
Appearance icon to set the chart layout. A bar chart inserted into a table cell can display a
second measure, while a micro chart can display multiple measures.
For standard columns, click the Edit icon to specify, 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 (
) and specify the total aggregation (
).
Tip
When you open a child panel, click Back at the bottom of the panel to return to the previous panel.
You inserted charts into the Grid widget. The charts are displayed in each cell of the specified columns.
To remove a column from the grid, move the mouse pointer to a column in the Set up panel. Different icons are displayed. Click Delete.
Example
The example shows a Grid widget with multiple columns of different data types and columns with bar charts.