2 Replies Latest reply on Apr 1, 2017 9:33 AM by pjsiong-JavaNet

    Apex 5.1 chart with multi series



      I define a chart region with 2 series, the sql in these 2 series are

      select 'SERIES1' SERIES,

      'TEST1' LABEL,

      90 VALUE1




      select 'SERIES2' SERIES,

      'TEST2' LABEL2,

      80 value2



      but Apex will stack the value in the same label 'TEST1' as below.

      Is there anything wrong?

        • 1. Re: Apex 5.1 chart with multi series
          Abyss Walker

          Hi guys!

          I have completely the same problem. Looks like Apex 5.1 seriaes charts are not working correctly.
          I have installed "Sample Charts" application in the Oracle Apex workspace.

          It have Bar Chart example appication. The Series Name Column Mapping example working ablosutely fine:


          But if I remove a order by in the SQL Query:

          It starts to generate different results:

          What the hell?



          My real use case doesn't work even with order by clause. It simply puts values to another buckets

          • 2. Re: Apex 5.1 chart with multi series

            Below is the reply from Oracle in another thread:

            In relation to the rendering of the data - JET requires that each series of the chart contain the same number of data points, otherwise it will just render them in the order in which they appear in the JSON object - which may not be the expected result.  The handling of nulls needs to be done by the query, but we may revise this behaviour in a future release.



            You can refer to

            Series Name in JET Charts