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.