Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 38)

Tips Recipes Brio 2002

Section Type: Chart section

Tip Name: Baseline Comparison Chart (using values from the database)

Purpose / Use: You often want to compare actual values with a target value that resides

in the database. This target value may change based on a number of

factors, so your comparison chart must key the baseline off data fetched

from the database.

Sample File: Data-based baseline comparisons.bqy

Steps to Produce: Brio Intelligence v6.x added support for creating summary computed

items that key off a single group total. This new summarization ability

can be used to create baseline comparison charts that work off a

reference value contained in the database itself.

1) Before creating the chart, select the Results section. Create a new Computed Item. Name

the item “Target”, “Baseline” or some other appropriate name. In this example, we want

to use the revenue figures for the state of New York as the baseline of comparison.

Therefore, enter the target value’s formula as the following:

Sum ( Revenue, State, 'NY' )

2) Create your chart as usual. Add the real value as the first Y-value and your new

computed Target item as the second Y-value.

3) Set the Chart Type to be Bar-Line (the last one in the toolbar pulldown list).

4) In the chart itself, select one of the values for the Target. Right-click, and select Data

Function from the speed menu. Change the data function from Sum to Maximum,

Minimum or Average (see the figure below).

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 38