Overview
Application Scenario
You can click the hyperlink to open the floating chart, as shown in the following figure.
Function Description
You can customize the title, width, and height of the floating chart.
You can add parameters to achieve the linkage effect.
The chart setting is the same as that in general charts. For details, see Chart Introduction.
Hyperlinks in floating charts cannot be previewed on mobile terminals.
You can set only the dataset data for the chart. Cell data is not supported.
You can pass parameters using hyperlinks. For details, see Hyperlink Parameter Passing.
You cannot use new calculation engines in the chart.
Note:Example
Template Preparation
1. Dataset creation
Create a dataset named ds1 with the SQL statement SELECT * FROM Sales_Volume.
Create a dataset named ds2 with the SQL statement SELECT * FROM Sales_Volume WHERE Region='${area}'.
2. Table design
Design the table as shown in the following figure and drag the corresponding fields from the dataset ds1 into the cells.
Hyperlink Adding
1. Select cell A2, select Chart Hyperlink-Floating Chart from the drop-down list to add a hyperlink, and set the chart type to Column Chart, as shown in the following figure.
2. In the Hyperlink setting item, modify the title, width, and height of the floating chart. Add a parameter, name the parameter area, and enter the formula =$$$ in Value. In this case, when you click a specific region in a cell, data of the region will be passed to the chart, as shown in the following figure.
3. Bind data from the dataset ds2 to the chart, as shown in the following figure.
4. Modify the chart title to = "Regional Sales Chart in "+$area, enabling the title to change dynamically with the parameter.
Effect Display
Save the template and click Pagination Preview. The effect is the same as that shown in section "Application Scenario."
You cannot preview Chart Hyperlink-Floating Chart on the mobile terminals.
Template Download
For details, you can download the template Hyperlinked to a Floating Chart.cpt.
