> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pba/9.3-analytics/pentaho-dashboard-designer-cp/advanced-topics/use-data-tables-in-a-dashboard/add-a-data-table-to-a-dashboard.md).

# Add a data table to a dashboard

Perform the following steps to add a data table to your dashboard:

1. Select a panel in the Dashboard Designer.
2. Click the **Insert** icon and select **Data Table**.

   The Select a Data Source dialog box appears.
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 the Plus Sign next to the category name to display its associated table columns. When the column names appear, click to choose the column that contains the data you want displayed in your data table.
5. Click the small yellow arrow to place the column name under **Selected Columns**.
6. Now add the **Conditions**.

   These are your constraints that filter what you are choosing. You can add multiple conditions:

   1. Under **Combine**, you can choose your constraint (**and**, **or**, **and not**, **or not**) from the drop-down list.
   2. 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).
   3. You can also choose 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 |

      Click **Preview** at any time to view the data associated with your query.
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.
8. Click **OK** in the Query Editor when you are done.

   The data table appears in the dashboard panel.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.pentaho.com/pba/9.3-analytics/pentaho-dashboard-designer-cp/advanced-topics/use-data-tables-in-a-dashboard/add-a-data-table-to-a-dashboard.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.