APEX

Hi Apex Gurus,

I have created a bar chart with two series based on two different date ranges (I am tracking Qtr1 and Qtr2 statuses). The possible values for closure statues are: 1) Closed; 2) Hold; 3) Unassigned; 4) Waiting on user; 5) Work in Progress.

When I run Q1, (I get 5 values):

SELECT
null link,
closure_status,
count(*) c
FROM
pgcps_sis_sra_requests
WHERE
date_received between '01-OCT-07' AND '01-DEC-07'
GROUP BY
closure_status

When I run Q2, (I get 3 values):

SELECT
null link,
closure_status,
count(*) c
FROM
pgcps_sis_sra_requests
WHERE
date_received between '01-OCT-07' AND '01-DEC-07'
GROUP BY
closure_status

PROBLEM: Because there are 5 values for the first Query and only 3 values for the second Query, the values automatically align at the left for the second query; this is not the desired behavior.

Can someone please tell me what I am doing wrong here or how I can fix this problem?

Thanks in advance,
CB