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.
Open a new SAP BusinessObjects Dashboards file and enter the data, as shown in the following screenshot, into the spreadsheet:
Drag a Trend Icon component into the canvas.
Enter this formula in spreadsheet cell B3: =B2-B1
.
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:
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...