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.
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:
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:
For December:
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.