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

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Charting Missing Data

Purpose / Use: You want to display a complete time series chart, even if data elements

are missing for certain time slots.

Sample File: Charting missing data.bqy

Steps to Produce: This solution uses a series of computed items to insert a zero when no

data exists for a time slot. By this technique, you take a single fact

column and “dimensionalize” it into numerous computed fact columns.

1) Build your query as normal and process it to fetch some initial data.

2) With the Results section selected, add a new Computed Item for each time series item to

test the presence of a value for that time slot. In the example, the time series is monthly, so

we create a computed item for each of the 12 months. The formula for testing the January

values based on the “Date” column would be:

if (ToChar ( Date, "mm" ) == "01") { Amount } else { 0 }

The Results section should look like this when all computed items have been defined:

3) Once all time series computed items have been added, build your chart, pivot or report

using all of the time series computed items.

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 33