Forum Stats

  • 3,852,558 Users
  • 2,264,113 Discussions


Dynamic Chart with multiple variables

Cleopatra Member Posts: 185
edited Mar 1, 2013 9:53AM in APEX Discussions
Hi everyone,

I have a question about the Apex charts and wondering if anyone could help.

The chart source query contains 3 variable page items and when I select the values and press the button
it refreshes the chart region.
However no data gets displayed and it seems as if the chart doesn't accept the values filled in the items.

Using Apex 4.1.1 and fire fox for browsing is there a way to fix this.
All help will be appreciated.

Kind regards,


  • TexasApexDeveloper
    TexasApexDeveloper Member Posts: 7,968 Gold Crown
    Simple question.. Are the items in session state? If they are NOT, then the chart will NOT see them..

    Thank you,

    Tony Miller
    Ruckersville, VA
  • Cleopatra
    Cleopatra Member Posts: 185
    Yes they are all in session state, so I'm I don't know why my chart returns no data.
    I had tried the chart query source in SQL commands and it does yield results.
    What else do you think that may be causing the chart not to see the values?

  • When nothing else seems to work, I start removing conditions from the query until I get some data displayed. If you remove the WHERE clause entirely, do you get all the rows returned? Are you displaying the page items on the page -- at least temporarily -- for debugging?

  • jwellsnh
    jwellsnh Member Posts: 1,816 Silver Trophy

    Possibly your chart series query is returning more rows than it has been allowed to display. Take a look at the Maximum Rows setting and see if increasing that solves your problem.

  • Good point!


    What is the result from the page display of the chart?
    1) A "No data found." message.
    2) Spinning icon keeps spinning, spinning, spinning, ...
    3) You get a blank screen for ever and ever and ever ...

  • Cleopatra
    Cleopatra Member Posts: 185
    What happens is that I see the values in first series of the graph which uses one variable and the second series uses three variables but I don't see the second series in the graph.

    Yes I see the values of the items. One of them is is an pop up lov the rest are select lists and date picker fields.
    How can I make sure the variable values are also used in the second series.

  • Cleopatra
    Cleopatra Member Posts: 185
    I don't see any of the three situations.
    The maximum number of rows does not get exceeded.
    I just see the first series which uses one variable, but the the second series I do not see which should be receiving values from 3 other variables.

  • Cleopatra
    Cleopatra Member Posts: 185
    Hi Jeff,

    The maximum number of rows does not get exceeded.

  • Howard (... in Training)
    Howard (... in Training) Member Posts: 905
    edited Feb 15, 2013 1:44PM
    There are a couple things about series charts which may seem a little subtle.

    1) The x-axis is basically labels. One value displays per label per series. So if your data has series1 points (label-a, y=1) (label-b, 2) (label-b, 2.5) then you might get (x=b,y=2) or (b,2.5) but it will not display both.
    2) Supose you have 3 series. Unless you have a series point for each series for each label, for example, series1 (a,1) series2 (a,20) series3 (a, 15), you'll get breaks in the series and they may not seem to stack over one another -- which is likely what you want with a multi-series chart. (There seems to be a way to handle missing data and to get interpolation, but that's a little more advanced.)
    3) If you have more labels -- or is it points -- than the max you set for your chart, it will only display the max. But if you are sorting the labels, it doesn't choose the first n, instead it retrieves up to the max points and then plots those. So if you had Mon-Fri data but had a max of 3, you might see Mon, Thu, Friday data because those three were (randomly?) retrieve first -- Oracle queries unordered -- and then sorted.

    Do you have a data point in each series for each label?

    Howard (... in Training)
  • Cleopatra
    Cleopatra Member Posts: 185
    Sorry for my late reply and thank you all for being so helpful.
    The queries for the series were all correct and so were the chart settings.
    Values in the session state were set, and I created a refresh dynamic action for refreshing the chart region.
    But I also see an option for asynchronous update which I set to "yes" in the refresh section
    and it seemed to be working just the way I wanted it.

    I appreciate you taking your time to help

This discussion has been closed.