1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Two Reports on single Graph

Discussion in 'Oracle Application Express (APEX)' started by Bharat, Jun 13, 2014.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi All,

    We have an report which contains Chart Report to display the Month wise for two years (current and previous years) sales amount done. And Y-Axis interval is designed based on the amounts (0 to 10,000,000 and soon), On X-Axis interval is (Jan, Feb,Mar.. Dec) each month with 2 bar lines (2013 and 2014). Now we want to embed another report on this report as need to display the items count for each month wise for two years with lines representation, and the Y-Axis intervals for these values are (0 to 1000, soon) as these values are very less below 5000. Please suggest us on this to achieve.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi All,

    Is it possible to embed another 2 y-axis lines graph for each x-axis on existing 2 y-axis bars graph for each Y-Axis ?

    We want to use another Y-Axis to achieve this. Can anyone please suggest an solution on this.
     
  3. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    For a standard 2-D or 3-D Graph report...simply create a new series on the report page.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi DTSIGuy,

    We have added the series but for each series we have 2 y-axis bars for 1 x-axis value. So I want to use 2nd Y-axis by providing 1st series (2 Y-Axis Values for each X-Axis Value) for 1st Y-Axis and 2 series (2 Y-Axis Values for each X-Axis Value) for 2nd Y-Axis.
     
  5. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    I don't believe you can do that. Each chart is independent of each other. You may have to make XML mods to the chart engine itself...which I have no idea how to do. Perhaps you should post the question on the Oracle APEX Forum. And set up an example at Oracle's hosted site.
     
    Bharat likes this.