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

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.

主站蜘蛛池模板: 增城市| 洛南县| 宁河县| 屏边| 若尔盖县| 景德镇市| 原阳县| 文成县| 建始县| 虎林市| 福安市| 长岛县| 白河县| 清流县| 松江区| 汪清县| 砚山县| 丽水市| 鄂尔多斯市| 平邑县| 虞城县| 沾化县| 会昌县| 大石桥市| 定西市| 永登县| 滁州市| 东至县| 尼木县| 凤庆县| 崇文区| 哈巴河县| 朝阳县| 江源县| 汉川市| 新安县| 墨脱县| 惠水县| 敖汉旗| 响水县| 祁阳县|