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

Tips Recipes Brio 2002

Section Type: Chart section

Tip Name: Portion within a Category

Purpose / Use: Pie charts are good for displaying “portion of the whole” comparisons.

Sometimes, you may want to display the portion of just a single item

within each of several categories at the same time.

Sample File: Percent of category.bqy

Steps to Produce: At Brio, we track Problem Reports and want to know how many are

closed versus the total for each category. The secret here lies in using a

Grouping Column in a unique way.

1) In the Results section, create a Grouping Column on the status item you want to use (i.e.,

the one that determines whether a PR is closed or not in our example). Place any status

that is considered closed in a group called Closed, and place all other status descriptions

in a group called Total PRs Entered.

In other words, instead of calling these other items Not Closed, we are intentionally

“mislabeling” them in the interests of our end result, the portion chart. Therefore, it is

important that the group label we “misuse” is set so that it falls later in the alphabet. That

way, it gets charted last.

2) Insert a new chart and set its type to Vertical Stack Bar (3

icon from the top in the

toolbar’s list of chart types).

3) Drag the amount / count field into the Y values. Place the new Grouping Column in the Z

labels area. Place an appropriate category label in as the X labels.

4) Set the legend to be based on the Z labels.

5) Modify the chart and turn off the 3-D Objects option.

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 46