Grapph/Bar

building reports desktopintelligence
1

If I section on a graph, for some reason it is giving the same color for two different things.

I have a graph which contains closed, open and terminated cases. Blue is closed, orange is open and grey is for terminated cases.

I sectioned by drug and got five different graphs as there are only five drugs. The 4th drug has only 1 closed case. It gives blue color. The 5th one has 1 terminated case. For some reason it is also giving blue color. But it should give grey color.

Do you know how can I correct it ? I am not much familiar with this type of charts.

Thanks

Developer_Designer (BOB member since 2009-08-09)

2

You need to use outer join in your query to get null values. So that for each drug you get all cases.

Beacause in graph legend is color is taken by row not by value in the row.

Rakesh_K :india: (BOB member since 2007-12-11)