- SAP BusinessObjects Dashboards 4.1 Cookbook
- David Lai Xavier Hacking
- 525字
- 2021-07-23 19:44:03
Using sparklines
Sparklines are typically small graphics, showing a horizontal line connecting several data points without labeling the values on their axes. The purpose of a sparkline is to show the movement of a trend over a certain period. Since its details are not available, the context of a sparkline must be clear to the dashboard user to interpret its meaning properly. This recipe will show you how to configure a sparkline.
Getting ready
Open a new file in SAP BusinessObjects Dashboards and enter the data into the spreadsheet, as shown in the following screenshot:

How to do it...
- Drag a Sparkline Chart component into the canvas.
- Bind the By Range field to the spreadsheet range from A4 to M5.
- Bind the Chart field to cell A1 and bind the Subtitle field to cell A2.
- Go to the Behavior tab of the properties pane of the Sparkline Chart component. In the Normal Range Area section, select Normal Range Area.
- Enter the value
600
in the Normal Range Low field and enter1000
in the Normal Range High field: - Go to the Appearance tab and select the Text sub-tab.
- Select Show for Start Value.
- Set the Position for this Start Value text to Left.
- Select Show for the End Value option.
- Now go to the Color tab and select all markers:
- Your dashboard should look like what is shown in the following screenshot:
How it works...
The configuration of the General tab within the properties pane of a sparkline chart component looks like the configuration of a line chart component. But, a sparkline chart component has fewer options here: no axis and no category labels can be defined. From a dashboard user's perspective, this also means that the user has to know and understand the context of the presented data. When multiple sparklines are displayed and they all have different bands without axes, it is very difficult to compare the values. The user needs to be aware of this.
With the Normal Range Area section in the Behavior tab, it is possible to illustrate the range of the values of this series. Also, the start and end and the highest and lowest values of the presented series can be emphasized.
There's more...
In this section, we will discuss some specific labels for the sparkline component: header labels and low and high values.
Header labels can label two parts of the sparkline chart component: the series name(s) and the sparkline(s). To activate these labels follow the given steps:
- Bind the Header Labels field in the General tab to two spreadsheet cells.
- Enter the value of the series name(s) header in the first cell, and the value of the sparkline(s) header in the second cell.
- Now go to the Appearance tab and select the Text sub-tab.
- Select Header Labels. The labels will now appear in the component, as shown in the following screenshot:
- 數據庫原理及應用(Access版)第3版
- Effective C#:改善C#代碼的50個有效方法(原書第3版)
- Building a RESTful Web Service with Spring
- Mastering SVG
- Scala Design Patterns
- 跟老齊學Python:輕松入門
- 面向STEM的Scratch創(chuàng)新課程
- Effective Python Penetration Testing
- Go語言精進之路:從新手到高手的編程思想、方法和技巧(2)
- RealSenseTM互動開發(fā)實戰(zhàn)
- MATLAB GUI純代碼編寫從入門到實戰(zhàn)
- 寫給大家看的Midjourney設計書
- Unity Android Game Development by Example Beginner's Guide
- 啊哈C語言!:邏輯的挑戰(zhàn)(修訂版)
- Python繪圖指南:分形與數據可視化(全彩)