- SAP BusinessObjects Dashboards 4.1 Cookbook
- David Lai Xavier Hacking
- 309字
- 2021-07-23 19:44:04
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...
- Drag a Waterfall Chart component into the canvas.
- Bind the Values field to the spreadsheet range from B3 to M3.
- Bind the Labels field to the spreadsheet range from B1 to M1.
How it works...
Instead of showing the total value for each category, the waterfall chart shows how an initial value (January) changes over time until it ends in the final value (December). To make this work, you have to make sure that the first and final values of your dataset represent the actual initial and final value. The other values that are in between should only represent the amount of increase or decrease of a value.
There's more...
There are four categories of values in a waterfall chart: initial value, final value, positive value, and negative value. These values all have their own color. Initially, the positive values are green and the negative ones are red. In the Series sub-tab within the Appearance tab of the properties pane, you can change the color of each type of value:

- Cocos2d Cross-Platform Game Development Cookbook(Second Edition)
- Web前端開發技術:HTML、CSS、JavaScript(第3版)
- Qt 5 and OpenCV 4 Computer Vision Projects
- Intel Galileo Essentials
- Learning Real-time Processing with Spark Streaming
- Mastering Spring MVC 4
- Building a Recommendation Engine with Scala
- QGIS By Example
- 零基礎趣學C語言
- RealSenseTM互動開發實戰
- Clojure for Machine Learning
- Spring+Spring MVC+MyBatis從零開始學
- Learning Hadoop 2
- 深度實踐KVM:核心技術、管理運維、性能優化與項目實施
- 基于GPU加速的計算機視覺編程:使用OpenCV和CUDA實時處理復雜圖像數據