Below are general instructions for creating content links in an Analyzer report, (inside a dashboard), that can be used to drive the parameter values of content in other dashboard panels. You must adjust the instructions when working with your own data.
- Create a simple dashboard that contains an Analyzer Report and a data table. At this point, none of the content has been linked and you have a "static" dashboard.
In the example above, when content linking is achieved, the list of territories (APAC, EMEA, Japan, and NA) will become hyperlinks that, when clicked, will update customer details data table. To get the correct filter display, a parameterized query that drives the content in the data table must be created.
- Add a parameterized condition to the query for the data table by specifying a parameter name in curly braces in the Valuetext box; then, provide a default value for that parameter in the Default text box. In the example below, a parameter called TERRITORY with a default value of NA has been created. 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 choosing an item from a filter control or following links defined in content associated with another panel in the dashboard.
Under General Settings, click the data table and examine its available parameters. In the example below, there is an available parameter called TERRITORY with a default source value of NA (North America). A drop-down arrow in the Source text box indicates that there are additional values to control the available parameter. In this example, there are no additional source values that control the TERRITORY parameter.
- Under General Settings, choose the Analyzer report. Click the Content Linking tab then click the check box next to the field/column name you want enabled for content linking. Click Apply.
In the Analyzer report, the values under the Territory become hyperlinks.
- Under General Settings, choose the data table and examine its available parameters. Notice that there is a drop-down arrow in the Source text box. Click the down arrow to display and choose a new source value for the available parameter. Click Apply.
- Save your dashboard.
In the example below, content linking was applied. When users click a territory hyperlink in the Analyzer report, the data table updates and displays customer-related details associated with that specific territory exclusively.