Using Business Intelligence Dashboard Designer : Using Content Linking to Create Interactive Dashboards : Content Linking and Query Parameters : Linking Charts and Data Tables
  

Linking Charts and Data Tables

Below are general instructions for linking charts and data tables in a dashboard. This is just an example. You must adjust the instructions when working with your own data.
1. Create a simple dashboard that contains a chart and a data table. At this point, none of the content has been linked and you have a "static" dashboard.
http://infocenter.pentaho.com/help/topic/puc_user_guide/images/48_simple_dshbrd_sample.png
Notice the pie chart in the example above. You want dashboard consumers to click a slice (NA, APAC, Japan, EMEA) and have the data table on the right update with the values associated with that slice exclusively. For example, if a report consumer clicks the EMEA slice, the data table will display values associated with EMEA and nothing else. To get the correct filter display, you must first create a parameterized query that drives the content in the data table.
2. Click the Edit button to open up the Edit pane at the bottom of the screen. Within the Objects pane, select the report you want to parameterize.
Note: Parameterizing a query, as described here, allows you to pass values dynamically and update the chart based on events triggered by other elements of the dashboard such as a user selecting an item from a filter control or following links defined in content associated with another panel in the dashboard.
3. Click on the {p} button next to the Title box. The parameters will populate after the title within the Title box.
4. Click on the Parameters tab and ensure that the parameters name is linking to the correct Source.
5. Click Apply.
The new source for the parameter corresponds to the title of the dashboard panel that contains the chart as shown in the example above. This new source will now drive the display in the data table.
6. Click on the Edit button (pencil icon) to exit the edit mode. The filters will appear after the panel titles.
7. Save your dashboard. See Saving Your Dashboard, below.
When users click a pie slice or bar in a chart, the data table displays content associated with that specific pie slice or bar. The currently applied filters appear after the title.