Drilling down from a chart

Being able to drilldown from higher level data to more granular detail is a very important feature in Dashboard Design. We want to be able to retrieve high level and granular level data easily without hunting for it. Using drilldowns, users can easily navigate through the different levels of data.

Getting ready

Insert two charts onto the canvas (Parent = Column Chart; Child = Line Chart). Data from the child chart is driven from the parent chart.

Tip

Please refer to the example source file Drilling down from a chart.xlf on how to set up and bind the data appropriately to the charts.

How to do it...

  1. In our example, the parent chart contains Regional Sales information. The child chart contains a drilldown of a monthly trend. ...

Get SAP BusinessObjects Dashboards 4.0 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.