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

Showing a trend without a chart

Showing a trend with a line chart is very useful if you want to show data over more than two periods. In some cases, all this historical information is unnecessary and you only want to display the direction of the trend—up, down, or no change. The trend icon component delivers this functionality. This recipe will show you how to use it.

Getting ready

Open a new SAP BusinessObjects Dashboards file and enter the data, as shown in the following screenshot, into the spreadsheet:

Getting ready

How to do it...

  1. Drag a Trend Icon component into the canvas.
  2. Enter this formula in spreadsheet cell B3: =B2-B1.
  3. Now bind the Data field of the Trend Icon component to cell B3. The Trend Icon component will now turn red and show a downward arrow:
    How to do it...

How it works...

The trend icon component can only be bound to a single cell. If this cell has a positive value, the component will be shown in positive state (arrow up). If the value is negative, the component will turn into its negative state (arrow down). If the value is zero, a neutral state is shown (flat line icon):

How it works...

We used the formula to calculate whether the change in trend is positive, negative, or neutral.

主站蜘蛛池模板: 视频| 和硕县| 化州市| 浦县| 法库县| 普格县| 柯坪县| 尚志市| 襄樊市| 富民县| 永宁县| 三穗县| 吴旗县| 大理市| 平利县| 哈巴河县| 襄垣县| 手游| 罗城| 安西县| 土默特左旗| 福贡县| 泾阳县| 永康市| 林甸县| 乐亭县| 益阳市| 闸北区| 石泉县| 郸城县| 稷山县| 苗栗县| 五峰| 祁阳县| 高阳县| 京山县| 鄂托克前旗| 若羌县| 绥棱县| 潼关县| 曲周县|