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.
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?
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.
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?
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.