To view all the database tables associated with a workspace, select the Datasets tab. To filter the list of available database tables, use the dropdown labelled 'Show' to filter the list. You can also search for and filter the shown items by typing the name of the table into the search box at the top of the list. Once the database table you want to work with is visible, you can view information about it. Simply click anywhere on the row, other than the table name or icon, to highlight it and summary information about the table will be shown in the Information tab located in the right-hand sidebar. This information may be out of date if the table has been recently updated, so it's good practice to refresh this summary by clicking the 'Run analyse' button.
To view the contents of a database table, click the 'Preview data' button to reveal a pop-up showing a high-level preview of a table's contents.
Opening a database tableTo view the table content in more detail, click on either a table name or its associated icon to open a dedicated tab showing the table’s fields and visualisation options. Clicking on multiple tables will open multiple table tabs. To show only certain table fields, use the search box to enter part of a column’s name.
To visualise data within a data table, click the 'Visualise' button, then:
- Choose one of the chart types.
- Choose one or more fields for the display (some charts only allow one field).
- Optionally set up one or more filters, choosing field, operator, and value.
- Click the 'Create chart' button.
The resulting data visualisation will appear in a pop-up window. You can edit the filters used to create the original visualisation by clicking the 'Show options' button. If you change the filters but aren't happy with these changes, click on the 'Revert' button. Once you are ready to apply your new filters, click the 'Refresh visualisation' button to see how the output has changed and save it as either a file or desktop image, or as a note attachment which can be shared with other members of your team.