Link Columns in a Data Table to Content in other Dashboard Panels
The instructions that follow 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.
- 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 above. 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.
- 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 below, a parameter called Productline with a default value of Classic Cars has been created.
- In the Chart Designer, set the data definitions for the series, category and values columns associated with your bar chart and click OK.
- 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.
- 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.
- Save your dashboard.
- 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.