Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By : David Lai
Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

By: David Lai

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
16
Index

Adding alerts to a column chart


When looking at a column chart, we might want to see which items are below or above a particular threshold. In this recipe, you will learn how to add alerts to a column chart. Our example will consist of a column chart with a list of regions and their sales. Each region column will be colored appropriately, depending on its sales value versus threshold.

Getting ready

Make sure you set up the sales data and threshold values as shown in the following screenshot. You'll also need to insert a Column Chart component into the canvas.

How to do it...

  1. First, bind the sales data to the chart as shown in the following screenshot:

  2. Go to the Alerts section of the chart properties and ensure that Enable Alerts is checked.

  3. Select alerts By Value as we will be comparing our sales data to the threshold values.

  4. In the Alert Thresholds section, click on the Use a Range checkbox. Bind the data to the threshold data that was set up in the Getting ready section.

  5. In the Color Order section...