Exploring and visualising your data

datasets iconTo view all the database tables associated with a workspace, select the Dataset tab. To filter the list of available database tables, use the dropdown labelled 'Show' to filter the list.

datasets with menu

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. datasets with search box

datasets sidebar

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. data preview

Opening a database table

To 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. table

To show only certain table fields, use the search box to enter part of a column’s name.

Rapid visualisation

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.

visualise options

The resulting data visualisation will appear in a pop-up window. visualise popup

![show options button](/img/userguides/showOptions_button.png#floatRight)

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.

Updated on December 1, 2020

Was this article helpful?

Related Articles

Not the solution you were looking for?
Click the link below to submit a support ticket