Friday, April 17, 2009

OBIEE Showing zero's in a bargraph

Somebody asked me how you can show zero's (0) in a bargraph. Have a look at this table:

image

If you put this in a normal barchart you get:

image

For product 13 and 14 it i'sn't clear if the data is missing (NULL) or is zero (0). One way of making it visible is this: Add an extra column which only shows the zero's (case when...):

image

(In the final report you can hide it)

Covert your chart to a bar/line type:

image

Sync the axis:

image

Supress the line and set the symbol:

image

Have a look at the results:

image

Till Next Time

1 comment:

Anonymous said...

This workaround sounds good. Is there any option for horizontal bar graph too to show 0 values.