Use data tables in a dashboard

Use a data table to show query results in a dashboard panel.

Data tables are interactive. Viewers can sort, resize, and reorder columns.

Add a data table to a dashboard

1. Select a panel in the Dashboard Designer.

2. Select Insert > Data Table.

   Select a Data Source opens.

3. Select a data source.

4. Select OK.

   The Query Editor opens.

5. Build your query.

   1. Expand a category to show its columns.

   2. Select the column you want.

   3. Select the yellow arrow to add it to Selected Columns.

6. Add conditions.

   Use conditions to filter results. You can add multiple conditions.

   1. Under Combine, select the operator: and, or, and not, or or not.

   2. Under Comparisons, select the comparison operator, such as =, <, or >.

   3. Optional: For numeric columns, select an aggregation type:

      • SUM: Sum of values

      • COUNT: Count of values

      • AVG: Average of values

      • MIN: Minimum value

      • MAX: Maximum value

   Select Preview at any time to review results.

7. Add one or more Order By columns.

   Order By controls sorting of the returned rows.

8. Select OK.

   The data table appears in the selected dashboard panel.

Update the data table display

Edit the data table display directly in the dashboard panel.

Sort, show, or hide columns

1. In a column header, select the drop-down arrow.

2. Select Sort Ascending or Sort Descending.

3. Optional: Clear a column checkbox to hide that column.

Resize a column

1. Select the right edge of the column header.

2. Drag left or right.

Reorder columns

Drag a column header to the new position.

Use pagination

Use pagination to page through large result sets.