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

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.

主站蜘蛛池模板: 璧山县| 天水市| 厦门市| 明水县| 南乐县| 长垣县| 无棣县| 禹城市| 田林县| 会理县| 泗洪县| 兴隆县| 闸北区| 阜城县| 晴隆县| 汕头市| 广宗县| 武安市| 白朗县| 灵宝市| 阳城县| 梓潼县| 阜阳市| 合水县| 鞍山市| 临海市| 蓝山县| 青冈县| 南丰县| 措美县| 汉沽区| 来凤县| 霍林郭勒市| 湟源县| 承德市| 闻喜县| 垣曲县| 军事| 招远市| 高安市| 龙井市|