Data Table

The Metadata Table panel shows the data that was uploaded as a spreadsheet (usually CSV) either at initial upload or during addition of more data tables using the add panel tool.

See Metadata Data for data source guidance.

The look of the Data Table can be formatted and sorted, and the table can be used to select (highlight) data on other panels or filter data on other panels.

Formatting table

Show/hide column in table

To hide a column, you can either click on the icon or uncheck the column in the Columns configuration menu (lozenge)

To show a column, the Columns lozenge and re-check the column's checkbox.

Set column width in table

The width icon will automatically set the width of the column to fit the contents. For columns with a lot of text this will expand the column enabling all the data to be viewed, and for columns with short headers and values, this will shrink the column.

Renaming columns

See Renaming columns

Reorder columns

Column order can be manually changed. Hover over the left side of the column name, and when the hand icon appears, click and drag the column right or left to the desired location.

Reorder columns

Set row density in table

The density of the rows can be altered by clicking on the density lozenge which brings up the following dialog

Sort table by selected column

The AZ button sorts rows in ascending order

The ZA button sorts rows in descending order

Selecting data

To select (highlight) data across other panels by using the data table, click in the checkboxes on the left side of a row.

Filtering data

Any column in the data can be used to filter the data visualised on all panels. To filter by a column, hover over the column name in the metadata table header, and click on the filter icon. This will bring up a dialog box with options for filtering the data, depending on what kind of field the column is.

Always click on the APPLY FILTER button to apply the filtering conditions to the column

Filter by condition

Conditions are dependent on the type of column. Choose the condition and the value to apply as the filter.

Filter by value

To filter the column by selecting one or more specific values from the dataset, click on filter by values

• Search for specific text (or scroll)

• Select those values you want to include

Filter using a list

Users can also search metadata with a comma-separated list.

Navigate to your metadata table to the column of data you would like to filter or search on. Choose “Text in comma-separated values” as your filter by condition.

Type or copy/paste your comma-separated values into the filter criteria. Use the Reset Filter in the search bar to clear the filter.