Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Oracle APEX: Bar chart with multiple series
Oracle APEX: Bar chart with multiple series [message #666069] Wed, 11 October 2017 06:42
fakt7
Messages: 3
Registered: October 2017
Junior Member
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.

https://i.stack.imgur.com/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 is not correct:

https://i.stack.imgur.com/xq3Kr.png


For Clerk there are no values in chart but there must be two emp. for December.
This is output of mentioned queries from sql developer (with correct values):

For April:

https://i.stack.imgur.com/W4M8y.png


For December:

https://i.stack.imgur.com/WJYB1.png


There is no problem when i use only one serie, problem is only with multiple series. I use Apex 5.1 with Oracle 12c.

[Updated on: Wed, 11 October 2017 06:44]

Report message to a moderator

Previous Topic: Send report in email body and not as attachment
Next Topic: how to change Document Direction in apex run time
Goto Forum:
  


Current Time: Thu Mar 28 09:19:44 CDT 2024