I. Overview
1) Hyperlink enables linkage among multiple cell elements from the same report.
2) Chart hyperlink enables linkage between data and data, between data and charts, and between charts and charts.
II. Steps
1. Create new datasets
1) Create a new dataset [ds1] and type the following SQL statement:
SELECT * FROM Sales_Volume
2) Create a new dataset [ds2] and type the following SQL statement:
SELECT * FROM Sales_Volume WHERE region='${region}'
3) Drag the data column [region] in ds1 into B2 and change the cell style.
2. Make a report
1) Right-click D3 and select Insert Chart in Insert Cell Element in the right-hand pane.
2) Change the chart type to Column Chart and select the second style.
3) Configure the following settings in the right-hand pane: [Dataset: ds2], [Category: Salesperson], [Series Name: Product], [Value: Sales_Volume], [Summary Method: Sum], and resize the cell.
3. Add hyperlink
1) Click on B2, select Hyperlink and then click + to add Chart Hyperlink-Link Cell.
2) Specify the column and row to be linked. Here we set D3 as the related cell.
3) Add parameter link to enhance the effect. Here we configure the following settings: [parameter: region], [Type: formula], [Value: B2].
4. Preview
1) In the Preview mode, because no cell is selected, no parameter will be passed and no chart will be displayed.
2) If you click North China or East China, values in the corresponding cell will be passed to D3 and then the sales chart will be displayed.
