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.
-
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.
-
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.
-
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.
In the example below, the Product Line column was enabled
for content linking.
