Skip to main content

Pentaho+ documentation has moved!

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

 

Hitachi Vantara Lumada and Pentaho Documentation

Link columns in a data table to other dashboard panels

Parent article
The instructions below show you how to link a chart to a column in a data table. You must adjust the instructions when working with your own data.

Procedure

  1. Create a simple dashboard that contains a data table and a bar chart. At this point, none of the content has been linked and you have a "static" dashboard.

    Notice the data table in the example here. You want dashboard consumers to click a product in the Product Line column and have the bar chart update with information about sales by territory for that specific product line. Link on column
  2. Add a parameterized condition to the query for the bar chart by specifying a parameter name in curly braces in the Value text box; then, provide a default value for that parameter in the Default text box.

    In the example here, a parameter called Productline with a default value of Classic Cars has been created. Parameter query
  3. In the Chart Designer, set the data definitions for the series, category and values columns associated with your bar chart and click OK.

  4. Under General Settings, choose the data table and click the Content Linking tab. Enable content linking on the column in your data table that will filter content in your chart.

    Each of the columns in a data table are able to broadcast values to other dashboard components.Value as link
  5. Under General Settings, choose the chart and click the Parameters tab. Click the down arrow in the Source text box to display another source for the parameter you created.

    In the example below, notice that Order Details - Product Line , (this is the name of the dashboard panel that contains the data table), can now be selected as a source for the Productline parameter.Select a new source
  6. Save your dashboard.

  7. In the data table, choose an item in the column that has content linking enabled.

    The content in the chart updates in response to the item that was clicked in the data table.
In the example below, the Product Line column was enabled for content linking.Bar chart with links