8 Replies Latest reply on Oct 30, 2017 11:25 AM by boris123

    Oracle APEX: Bar chart with multiple series

    boris123

      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.