Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle APEX: Bar chart with multiple series

boris123Oct 12 2017 — edited Oct 30 2017

I have problem with Bar chart (with multiple series) in Oracle Apex. For example i have created simple bar chart with two series (April, December) from emp table.

yhP1N.png

Source for series is SQL query.

For April:

    select job, count(job) as "Number of employees" from emp where to_char(HIREDATE, 'MON') = 'APR' GROUP BY job

For December:

    select job, count(job) as "Number of employees" from emp where to_char(HIREDATE, 'MON') = 'DEC' GROUP BY job

Problem is that generated chart has incorrect values:

xq3Kr.png

For Example : Clerk has no values in chart but there must be two employees for December.

This is output of mentioned sql queries from sql developer (with correct values):

For April:

W4M8y.png

For December:

WJYB1.png

Problem is only with multiple series. When i use only one serie generated chart has correct values. I use Apex 5.1 with Oracle 12c.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 27 2017
Added on Oct 12 2017
#apex, #apex-5-1, #apex-discussions, #oracle
8 comments
4,845 views