Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
16
Index

Using a waterfall chart


A waterfall chart is useful to visualize the fluctuation of a value in positive and negative values. The first and final values are displayed as full columns (starting at 0). The values in between represent the positive and negative fluctuations. A good example is the stock level of goods in a warehouse. A waterfall chart can show how it changes over time.

This recipe shows you how to set up such a waterfall chart.

Getting ready

Open a new SAP BusinessObjects Dashboards file and enter data in the spreadsheet as shown in the following screenshot. As you can see in row 3, the first and final value (January and December) show the total stock level, instead of the change relative to the previous period, as is shown in the other months:

How to do it...

  1. Drag a Waterfall Chart component into the canvas.

  2. Bind the Values field to the spreadsheet range from B3 to M3.

  3. Bind the Labels field to the spreadsheet range from B1 to M1.

How it works...

Instead of showing the total value for...