Configuring Chart Parameters > Drill-Down Chart Links

With the Drill Down Chart Links feature you can place links behind the plotted areas of a chart. Typical usage is to give the users the possibility to click on a chart element and get to a new page that can include a drill down chart or detailed explanations. For example, in the chart below, the user can click on the February column and get to a new page that includes a detailed chart with the February sales.

Setting up drill down links in Static Charts

Creating Drill Down charts for an existing chart consists in 2 steps:

• Generate the secondary chart (static or dynamic). The secondary chart is a regular chart created on a data subset of the main chart. In the example above, you should create a secondary chart to show the sales of John, Mary and Tom in February.
• Link the plotted area to the secondary chart. Attaching drill down links to the plotted area in the static charts is very easy. From the "Data Grid" tab, click on each value in the grid and set the link to the secondary chart and target.

Setting up drill down links in Dynamic Charts

As for the Drill Down links in Static charts (see above) you should first create the secondary chart (the chart where that the user can see after clicking on a plotted area in the main chart. To create the Drill Down link dynamically you need to add 2 fields in the database table: one to contain the drill Down link and one to indicate the link target.

To link the plotted areas accordingly to the database values go to the "Data" tab (Use data from already defined recordset screen) and click on "Add as series" button. In the pop-up you should fill in the Link field and select the column used to set the target. The link field should be composed from the URL of the secondary chart and the database column that contains the parameter that identifies the secondary chart.