Adding a Data Table to a Dashboard

The Data Table feature allows you to display a tabular representation of a database query in a dashboard. It also allows you and consumers of the dashboard to manipulate the display of the data in the data table, while in the dashboard. For example, users can resize, sort, and change the order of columns. Follow the instructions below to add a data table to your dashboard.

1. Select a panel in the Dashboard Designer.

3. Select a data source from the list of available data sources and click OK. The Query Editor opens.

4. Begin building your query. Click (+) next to the category name to display its associated table columns. When the column names appear, click to select the column that contains the data you want displayed in your data table.

5. Click the small green arrow to place the column name under Selected Columns.

6. Now add the Conditions; these are your constraints that filter what you are selecting. You can add multiple conditions. Under Combine, you can select your constraint (and, or, and not, or not) from the drop-down list. Under Comparisons you can click the drop-down list to display options for comparisons, =, <, >, and so on; (for example, where the Customer number is equal to 144 or 145). You can also select an aggregation type from the drop-down list for table columns that contain numeric data. The table below contains a definition for each aggregate type:

Aggregate Type	Description
SUM	Sums a column's values
COUNT	Counts a column's values
AVG	Averages a column's values
MIN	Selects the minimum column value
MAX	Selects the maximum column value

7. Add the columns that you want to Order By. The ordering of the selected data is accomplished by one or more columns in a table. For example, you can sort the data by Customer name and address.