Component Solution Services REC02F Instrukcja Użytkownika Pobierz pdf (Strona 45)

Tips Recipes Brio 2002

Section Type: Chart section

Tip Name: Spotlighting in a Chart

Purpose / Use: The Spotlighter is a very useful tool for visually tagging deviant values.

However, the Spotlighter is not available in the Chart section.

Sample File: Baseline and spotlighting.bqy

Steps to Produce: Here is how to create spotlighting by using layered computed items.

1) Create your chart as usual, with the actual value as the first Y value.

2) Right-click on the chart, and create a Computed Item. Name it something appropriate

like “Monthly Goal”. Set its definition to be your target value (say, 200000).

3) Create another Computed Item. Name it “Goal Not Met”, and set its definition to be:

if (Monthly_Goal > Amount) {Amount} else {0}

This formula creates a bar only when you have a value to spotlight.

4) Change the chart type to Vertical Stack Bar (3

icon from the top in the toolbar’s chart

type pulldown).

5) Drag the Goal Not Met field to be the first item in the Y values.

6) Set the legend to be based on the Y values. Use the Color Pallete to reset the colors for

each value series. One good setting is to use red for Goal Not Met (in front), blue for the

actual value (in the middle), and yellow for Goal (in the back).

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

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

Brak uwag

Component Solution Services REC02F Instrukcja Użytkownika Strona 45