Linking 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.
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 above. You want dashboard consumers to click on a product in theProduct Linecolumn 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 theValuetext box; then, provide a default value for that parameter in theDefaulttext box. In the example below, a parameter calledProductlinewith a default value ofClassic Carshas been created.
2. In the Chart Designer, set the data definitions for the series, category and values columns associated with your bar chart and clickOK.
UnderGeneral Settings, select the data table and click theContent Linkingtab. 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 is able to broadcast values to other dashboard components.
3. UnderGeneral Settings, select the chart and click theParameterstab. Click the down arrow, in theSourcetext box to display another source for the parameter you created. In the example below, notice thatOrder Details - Product Line, (this is the name of the dashboard panel that contains the data table), can now be selected as a source for theProductlineparameter.
4. Save your dashboard. SeeSaving Your Dashboardbelow.
5. In the data table, select 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, theProduct Linecolumn was enabled for content linking.
