Adding Tables as Dashboard Tiles

Adding a table visualisation to a dashboard

One dimensional tables can be added to a dashboard by choosing the Table type from the tile editor panel.

Note: To see data in the table, you need to add one dimension and at least one measure.

Adding a dimension and measures

The following example table has one dimension (Region) and four measures.

The dimension can be any variable except text and reference variables, and is set in the Data panel.

The four measures are:

  • A count of households

  • A count of people

  • The mean booking cost

  • A calculated measure of bookings per person

These measures are also set in the Data panel. The first measure is used for sorting and category display. The measures look like this:

Editing the column headers

The column headers can be changed in the Axis Titles panel. The default headings are displayed, and they can be overwritten as required.

Sorting and categorising the display

The first measure on the table can be sorted, and used to calculate the number of categories to display if required. This example shows the top ten categories, and the rows are sorted in a descending order. These settings are in the Data Options panel:

Exporting the table

The table can be exported to Excel or PDF. This function is located in the Advanced Options menu, under an ellipsis on the dashboard tile.