9 Replies Latest reply on Oct 3, 2017 1:00 PM by Oleh Tyshchenko

    Oracle APEX 5.1 stacked bar chart

    Pulakeshdey1977

      Below is the query used and got below report. Can someone help me what is the issue and how to solve it?

       

      Query used:

      select null link, 'ASPENTECH' label, 'P1' series, 1 VALUE from dual

      union

      select  null link, 'ASPENTECH' label, 'P1' series, 2 value from dual

      union

      select  null link, 'Apex Tech-ops' label, 'P3' series, 1.5 value from dual;

      union

      select  null link, 'Apex Tech-ops' label, 'P3' series, 0 value from dual;

       

      Column mapping is as below:

       

      The wrong output I got as below.

       

      Regards,

      Pulakesh

        • 1. Re: Oracle APEX 5.1 stacked bar chart
          fac586

          3295880 wrote:

          Please update your forum profile with a recognisable username instead of "3295880": Video tutorial how to change nickname available

          Below is the query used and got below report. Can someone help me what is the issue and how to solve it?

           

          Query used:

          select null link, 'ASPENTECH' label, 'P1' series, 1 VALUE from dual

          union

          select null link, 'ASPENTECH' label, 'P1' series, 2 value from dual

          union

          select null link, 'Apex Tech-ops' label, 'P3' series, 1.5 value from dual;

          union

          select null link, 'Apex Tech-ops' label, 'P3' series, 0 value from dual;

           

          Column mapping is as below:

           

          The wrong output I got as below.

          Why do you consider this to be the "wrong output"?

           

          What result are you trying to achieve?

          • 2. Re: Oracle APEX 5.1 stacked bar chart
            Pulakeshdey1977

            Hi,

            Thanks for the advice and response.

             

            for clarity just changed the query a little and stacked property to "No"

             

            Query:

            select null link, 'ASPENTECH' label, 'P1' series, 1 VALUE from dual

            union

            select null link, 'ASPENTECH' label, 'P3' series, 2 value from dual

            union

            select null link, 'Apex Tech-ops' label, 'P3' series, 1.5 value from dual

            union

            select null link, 'Apex Tech-ops' label, 'P1' series, 1 value from dual

            union

            select null link, 'Artwork' label, 'P4' series, 1.5 value from dual

            union

            select null link, 'Artwork' label, 'P3' series, 1 value from dual

            union

            select null link, 'Artwork' label, 'P2' series, 3 value from dual

            union

            select null link, 'Artwork' label, 'P1' series, 1 value from dual;

             

            The output is as below from apex 5.1:

            Actual output should be:

             

            Though there is a color coding difference but looking at the plotted chart its clear that ASPENTECH should have only two BAR one for P1 and another P3.

            Apex is giving me 4 BARs which is completely wrong.

             

            once again I am giving the column mapping below what I made in apex:

             

            Hope this time problem statement would be very much clear to you.

            • 3. Re: Oracle APEX 5.1 stacked bar chart
              fac586

              Pulakeshdey1977 wrote:

               

              for clarity just changed the query a little and stacked property to "No"

               

              Query:

              select null link, 'ASPENTECH' label, 'P1' series, 1 VALUE from dual

              union

              select null link, 'ASPENTECH' label, 'P3' series, 2 value from dual

              union

              select null link, 'Apex Tech-ops' label, 'P3' series, 1.5 value from dual

              union

              select null link, 'Apex Tech-ops' label, 'P1' series, 1 value from dual

              union

              select null link, 'Artwork' label, 'P4' series, 1.5 value from dual

              union

              select null link, 'Artwork' label, 'P3' series, 1 value from dual

              union

              select null link, 'Artwork' label, 'P2' series, 3 value from dual

              union

              select null link, 'Artwork' label, 'P1' series, 1 value from dual;

               

              The output is as below from apex 5.1:

              Actual output should be:

               

              Though there is a color coding difference but looking at the plotted chart its clear that ASPENTECH should have only two BAR one for P1 and another P3.

              Apex is giving me 4 BARs which is completely wrong.

               

              once again I am giving the column mapping below what I made in apex:

               

              Hope this time problem statement would be very much clear to you.

              APEX 5.0 JET charts require the same number of data points to exist in each series: Series Name in JET Charts

               

              You have to perform the required data densification in the source query:

               

              select null link, 'ASPENTECH' label, 'P1' series, 1 VALUE from dual
              union
              select null link, 'ASPENTECH' label, 'P2' series, null value from dual
              union
              select null link, 'ASPENTECH' label, 'P3' series, 1 VALUE from dual
              union
              select null link, 'ASPENTECH' label, 'P4' series, null value from dual
              union
              select null link, 'Apex Tech-ops' label, 'P3' series, 1.5 value from dual
              union
              select null link, 'Apex Tech-ops' label, 'P1' series, 1 value from dual
              union
              select null link, 'Apex Tech-ops' label, 'P2' series, null value from dual
              union
              select null link, 'Apex Tech-ops' label, 'P4' series, null value from dual
              union
              select null link, 'Artwork' label, 'P4' series, 1.5 value from dual
              union
              select null link, 'Artwork' label, 'P3' series, 1 value from dual
              union
              select null link, 'Artwork' label, 'P2' series, 3 value from dual
              union
              select null link, 'Artwork' label, 'P1' series, 1 value from dual
              
              • 4. Re: Oracle APEX 5.1 stacked bar chart
                Pulakeshdey1977

                Thanks for the quick response. Will check quickly and get back.

                • 5. Re: Oracle APEX 5.1 stacked bar chart
                  Pulakeshdey1977

                  Thanks it worked for me. But its surely a bug any idea when we will have the solution?

                  • 6. Re: Oracle APEX 5.1 stacked bar chart
                    Hilary Farrell-Oracle

                    Hi Pulakesh,

                     

                    As Paul mentioned in one of his responses above:

                    APEX 5.0 5.1 JET charts require the same number of data points to exist in each series: Series Name in JET Charts

                     

                    You have to perform the required data densification in the source query:

                     

                    For 5.1, we intentionally left the 'densification' of the data to the customer to handle via their SQL query.  However, this has led to some confusion and numerous questions on the forum and at conferences, so we have revised that behaviour for our upcoming 5.1.3 patch set release.  In that release, we will now automatically handle the injection of missing data points, to ensure that the resulting JSON object meets JET's requirement of having the same number of data points, in each series of a multi-series chart, for each x-axis label.  I can't provide details of when 5.1.3 will be made available, so for now you can manage the densification in your query.

                     

                    Regards,

                    Hilary

                    • 7. Re: Oracle APEX 5.1 stacked bar chart
                      Shas

                      @Hilary - Now that 5.1.3 version is available just wondering if we apply this hopefully the data densification is taken care automatically?

                       

                      Thanks in advance

                      • 8. Re: Oracle APEX 5.1 stacked bar chart
                        Hilary Farrell-Oracle

                        Hi Shas,

                         

                        I've just responded to your other thread (https://community.oracle.com/message/14545045 ) where you've asked the same question.

                         

                        Yes - applying 5.1.3 should should automatically handle the filling in of any gaps in your data, to ensure the multi-series chart is rendered correctly.  There are 2 exceptions to this: if your chart is using the Time Axis Type attribute, and it is set to 'Mixed Frequency' or 'Skip Gaps'.

                         

                        Regards,

                        Hilary