Adding a Hyperlink to a Chart Dashlet
When working with chart dashlets in the Dashboard Designer, you can specify a link that opens when a user clicks the dashlet. You can optionally include a parameter which references an existing filter in another dashlet, and uses that filter to display a specific web page relevant to the filtered information.
The following example takes you through adding a hyperlink to the chart dashlet in the Sales by Gender dashboard created in Creating a Web Page Dashlet. The example also shows how to add a parameter to a hyperlink.
First, open the dashboard:
| 1. | If the Sales by Gender dashboard created in Creating a Web Page Dashlet (above) is not open, locate the /Dashboards folder in the repository. Right-click the dashboard name and select Open in Designer from the context menu. |
The Sales by Gender Dashboard appears in the designer.
Create a chart hyperlink:
| 1. | Right-click on the Sales Mix by Gender dashlet and select Properties.... |
The Dashlet Properties dialog box opens.
| 2. | Click the Hyperlinks tab. |
Hyperlinks tab in Dashlet Properties |
|
| 3. | Click Enable chart hyperlinks to select it. |
| 4. | Choose Open new page from the Action menu. |
The Web Address/Repository URI entry bar is displayed.
| 5. | Enter repo:/public/Samples/Reports/04._Product_Results_by_Store_Type_Report for the Web Address/Repository URI. |
| To see the report's path, hover over the report's name in the Existing Content pane. |
Preview the new dashboard functionality:
| 1. | Click |
| 2. | Click the chart dashlet. |
The 04. Product Results by Store Type Report opens in a new tab.
| 3. | Click |
Add a parameter:
| 1. | Right-click on the Sales Mix by Gender dashlet, select Properties..., and click the Hyperlinks tab. |
The Available Parameters area shows the parameters available in the chart.
| 2. | Modify the URL to add a parameter that provides a value for an input control in the target report: |
| • | You need to know the correct name of the input control in your target report. In this case it is sales__store__store_contact__store_country_1 in the 04. Product Results by Store Type Report. |
| • | Create a parameter. If you create a parameter name, it is helpful to use a name that is not used in the Filter Manager. In this example, use LinkCountry. For more information about parameters, see Specifying Parameters in Dashlets. |
The link is as follows:
repo:/public/Samples/Reports/04._Product_Results_by_Store_Type_Report?sales__store__store_contact__store_country_1=$P{LinkCountry}
| If you use one of the names in the Available Parameters list, the mapping to the parameter is created for you. In this example, if you use Store Country instead of LinkCountry, you do not need to create links in the filter manager. This example does not show how to add support when more than one country is selected. For more information, see Specifying Parameters in Dashlets. |
| 3. | Click Create Links in Filter Manager. Click Yes when prompted. |
The filter manager is displayed.
Filter manager |
|
| 4. | In the Customer Country filter group, click |
A new row with affected dashlet and filter/parameter dropdown menus appears.
| 5. | In the Dashlet Affected column, select 06. Sales Mix by Gender from the new Select dashlet... dropdown menu. |
| 6. | In the Filter/Parameter Affected column, select LinkCountry from the new Select parameter... dropdown menu. |
Finally, preview the new dashboard functionality:
| 1. | Click |
| 2. | Click in the Customer Country text box to display the available countries. |
| 3. | Select Mexico from the values list, and click Apply at the bottom of the dashlet. |
| 4. | Click the chart dashlet. |
The 04. Product Results by Store Type Report opens in a new tab.
| 5. | To verify that the parameter has been passed correctly, click in |
The Input Controls dialog box opens, with Mexico set.
| 6. | Return to the tab that contains your dashboard. |
| 7. | Click |
| 8. | Click |
Recommended Comments
There are no comments to display.