Component Solution Services REC02F Manuel d'utilisateur télécharger pdf (Page 52)

Tips Recipes Brio 2002

Section Type: Pivot section (yes, the pivot section)

Tip Name: Demographic Analysis

Purpose / Use: To graphically display trends of average values in an organization over

time or across different groups.

Sample File: Demographics.bqy

Steps to Produce: What appears as a simple chart may in fact require some imagination to

set up. In this case, preliminary work includes building a Computed

Item to transform the data into useable form, and then building the

analysis as a Pivot first. We then convert the Pivot to a Chart.

1) In the Results section, create a Computed Item. Call it Months Since Last Promotion, and

define its formula to be:

MONTHS_BETWEEN ( Today, Last_Promotion_Date )

2) Insert a new Pivot. Add the category as the left-side label, and the analysis grouping as the

top label. Place the new Computed Item (Months Since Last Promotion, in our example) in

as the data element.

3) Right-click on the data column and select Data Function from the speed menu. Change the

data function to be Average.

4) On the Brio main menu, select Insert | Chart This Pivot.

1 2 ... 47 48 49 50 51 52 53 54 55 56 57 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 52