HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Using alerters to highlight key results298
In this example, you want to flag products that have generated sales revenue of over 20%
of the annual sales revenue average, in just one quarter. First, using the Formula option
in the Alerter Editor, you build the following alerter:
Then, using the formula pane in the Alerter Display dialog box you specify the
character string “High performer” for the cell format:
This is the format that Web Intelligence will apply to the report cells where results meet the
condition defined in the alerter.
Lastly, you create an empty column next to the column for Lines and type the text “Rating”
into the new column header. You apply the new alerter to that column. (For full information
on how to add columns to tables, see ”Adding or removing table rows or columns” on
page 138.) The average sales revenue per product over the year in all states is $93,002.