Component Solution Services REC02F Bedienungsanleitung PDF herunterladen (Seite 35)

Tips Recipes Brio 2002

Section Type: Table section

Tip Name: Top and Bottom N Analysis

Purpose / Use: You want to create a TopN or BottomN analysis, with the user able to

select what value of N to use on the fly.

Sample File: Top and Bottom N.bqy

Steps to Produce: Allowing users to select the value of N means creating a dynamically

controlled limit. Unfortunately, you can’t create a limit on an aggregated

field such as a Rank or Sum. Using a Table section as the data staging

area allows you to place a limit on the controlling aggregate value.

1) In the Results section, create a Computed Item to determine the ranking. In this example,

we are looking at the revenue ranking by State.

2) For TopN analysis, create a Computed Item named “Revenue Rank” with a formula as

follows:

Rank ( Revenue, State )

3) For BottomN analysis, create a Computed Item named “Reverse Rank” with a formula as

follows:

RankAsc ( Revenue, State )

4) With the Results section selected, insert a new Table section.

5) Drag all regular fields into the Table design. Then add the appropriate ranking column to

the Table (Revenue Rank for a TopN analysis, or Reverse Rank for a BottomN analysis).

6) In the example of a TopN analysis, double-click on the new Table section in the catalog and

rename it to be called “TopN”.

1 2 ... 30 31 32 33 34 35 36 37 38 39 40 ... 77 78

Keine Kommentare

Component Solution Services REC02F Bedienungsanleitung Seite 35