Horizontal Stacked Chart

building reports webintelligence
1

Hello All,

Attached is a chart showing a pale yellow bar for last year and a bright yellow bar for current year with a red section indicating last month. There are two bars per the main dimension, called Key Hazard.

My problem is that for some Key Hazard/ Year combinations there is no data, for example ‘Using Power Tools’ has no 2007 data but I want to show 0 for it, i.e. show a value on the axis regardless. Any ideas?

Thanks, Steve

PS. My other issue is that not all values show on the axis: the bar above ‘Using Power Tools / 2008’, for example, is for ‘Security / 2007’. We all know about the poor charting functionality with WebI though so I’m not expecting a solution to that other than “make it bigger”!. :reallymad:
Horizontal Stacked.png

steveayres :uk: (BOB member since 2006-11-23)

2

When a query returns no results for some values of a dimension, you can’t just make them up in the report itself. You need to create a second query which returns all values of the required dimension (no measures) and use the merge dimensions function to synchronize both queries.
In the report you will use the “merged” dimension name or the dimension coming from the second query to build your graph.

Remember that you will need to merge all dimensions used in the graph and in all sections.

Marc Doucet :canada: (BOB member since 2007-07-11)