chart not displayed when values are equal

[rmh3619]

I have created a chart which shows two bars. one bar show new items in this month and the other shows closed items this month. the chart is created by joining 2 queries:

SELECT Null,Sum([CountOfCall_ID]) AS [SumOfCountOfCall_ID] FROM [Dashboard_New_calls_this_month] union SELECT Null,Sum([CountOfIncident_nr]) AS [SumOfCountOfIncident_nr] FROM [Dashboard_Closed_calls_this_month];

this works fine however, when the two values are equal only the new items bar is displayed.

How can i arange that in all cased the 2 bars are displayed?

thanks in advance

 

[GingerR]

How about adding a "Label" to each item:

SELECT "Call Count" as Title,Sum([CountOfCall_ID]) AS [SumOfCountOfCall_ID] FROM [Dashboard_New_calls_this_month] union SELECT "Incident Count",Sum([CountOfIncident_nr]) AS [SumOfCountOfIncident_nr] FROM [Dashboard_Closed_calls_this_month];

something like that. untested.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html