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

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Creating Range-based analysis

Purpose / Use: You may want to convert a measure with many discrete values into a

derived measure that groups these items into a set of value ranges.

For fields with many discrete values, creating a Brio Grouping Column is

often not appropriate. Grouping columns are unwieldy to deal with

when a large list of values is present, and are defined in such as way that

they can only handle a single contingency group for values not present

at definition time. A better solution exists using a Computed Item with

complex If-Then-Else logic defined.

Sample File: Results ranges.bqy

Steps to Produce: In this example, we want to define a column that displays in which

member in a range of values the revenue size of each order falls. We then

want to see how many orders fall into each size range.

1) In the Results section, add a new Computed Item. Call it Order_Size, and define its formula

to be:

if (Revenue <= 1000) {'$ 0 to $1000'} else {

if (Revenue <= 2000) {'$1001 to $2000'} else {

if (Revenue <= 3000) {'$2001 to $3000'} else {

if (Revenue <= 4000) {'$3001 to $4000'} else {

if (Revenue <= 5000) {'$4001 to $5000'} else {

'Greater than $5000' } } } } }

2) Add another Computed Item. Call it Order_Count and define its formula to be 1.

3) Use the Order_Size field as a label and the Order_Count field as a measure in your Pivots,

Charts and Reports.

1 2 ... 19 20 21 22 23 24 25 26 27 28 29 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 24