Drilling down from a chart
Being able to drill down from higher-level data to more granular data is a very important feature in SAP BusinessObjects Dashboards. We want to be able to retrieve high-level and granular-level data easily without hunting for it. By using drilldowns, users can easily navigate through the different levels of data.
Getting ready
Insert two charts into the canvas (Parent = Column Chart; Child = Line Chart). Data in the child chart is driven from the parent chart.
Tip
Please refer to the example Drilling down from a chart.xlf from the code bundle on how to set up and bind data appropriately to the charts.
How to do it...
- In our example, the parent chart contains Regional Sales information. The child chart contains a drilldown of a monthly trend.
- Turn on the drilldown capability from the parent chart by clicking on the Insertion icon and then on the Enable Data Insertion checkbox.
- Select the Insertion Type that you will use for the drilldown bars. In our case, we will drill...
