官术网_书友最值得收藏!

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:

Getting ready

How to do it...

  1. Drag a Sparkline Chart component into the canvas.
  2. Bind the By Range field to the spreadsheet range from A4 to M5.
  3. Bind the Chart field to cell A1 and bind the Subtitle field to cell A2.
  4. Go to the Behavior tab of the properties pane of the Sparkline Chart component. In the Normal Range Area section, select Normal Range Area.
  5. Enter the value 600 in the Normal Range Low field and enter 1000 in the Normal Range High field:
    How to do it...
  6. Go to the Appearance tab and select the Text sub-tab.
  7. Select Show for Start Value.
  8. Set the Position for this Start Value text to Left.
  9. Select Show for the End Value option.
    How to do it...
  10. Now go to the Color tab and select all markers:
    How to do it...
  11. Your dashboard should look like what is shown in the following screenshot:
    How to do it...

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

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:

  1. Bind the Header Labels field in the General tab to two spreadsheet cells.
  2. 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.
  3. Now go to the Appearance tab and select the Text sub-tab.
  4. Select Header Labels. The labels will now appear in the component, as shown in the following screenshot:
    Header labels

Low and high values

Besides the start and end values of a sparkline, you can also show the lowest and highest values. In the Text sub-tab of the Appearance tab, you can select them to be visible as shown in the following screenshot:

Low and high values
主站蜘蛛池模板: 无锡市| 临西县| 海盐县| 云阳县| 固始县| 增城市| 汝州市| 永新县| 嫩江县| 甘谷县| 永宁县| 确山县| 那曲县| 五华县| 台湾省| 婺源县| 二连浩特市| 方山县| 怀集县| 泽州县| 莆田市| 松潘县| 土默特左旗| 沾益县| 收藏| 丽水市| 夹江县| 利川市| 油尖旺区| 盘山县| 安乡县| 万源市| 孝义市| 穆棱市| 五河县| 鞍山市| 灌南县| 于都县| 沛县| 镇江市| 阿尔山市|