Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Use data tables in a dashboard

Parent article

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.

Add a data table to a dashboard

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

Procedure

  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 TypeDescription
      SUMSums a column's values
      COUNTCounts a column's values
      AVGAverages a column's values
      MINSelects the minimum column value
      MAXSelects 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.

Updating the data table display

You can edit the data table display directly in the dashboard panel.

  • Sorting Column Data

    To change the sort order data under a column, click the drop-down arrow in the header and choose Sort Ascending or Sort Descending. You can also hide one or more columns by disabling the appropriate check boxes next to the column names.

  • Adjusting Column Width

    You can adjust the width of a column by clicking the right border of the column header and dragging it to the right or left. Release the mouse button when you are done.

  • Moving Columns

    To move the placement of a column, click and drag the column to the appropriate location in the data table.

  • Paginating

    The pagination feature allows you to page through a large number of records.