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

Tips Recipes Brio 2002

Section Type: Chart section

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

Purpose / Use: You often want to compare actual values with an average of values that

reside in the database. Since this is a comparison against an average,

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 computed items that

key off the number of distinct groups rather than the number of rows.

This new summarization ability can be used to create correct baseline

averages for use in comparison charts.

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

the item “State Total” or some other appropriate name. Enter the computed item’s

formula as the following:

Sum ( Revenue )

2) Next, we need to calculate the number of state groups (rather than the total number of

rows). Create a second Computed Item called “State Cnt” with the formula:

CountDistinct ( State )

3) Now, create a third Computed Item that will hold the average revenue for an average

state. Name it “State Avg” and define its formula as:

State_Total / State_Cnt

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

computed “State Avg” item as the second Y-value.

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 40