This content has been marked as final. Show 7 replies
I found that the problem is in the 2D stacked Chart,
I use the SQL
select link,label, value1,value2,value3 from table
order by label
for the data source,
if some of the value1 or value2 or value3 is null value, the chart will display the data not in the "label" order,
even the sql has the "order by clause".
Can this consider as a bug in Apex or anychart? Anyone know if there any workaround?
As I want to display the value in chart, so I don't want to use nvl(value1,0) in the sql as it will display "0" in the chart.
Would select ... from ... where ... is not null order by label work for you?
If that is not giving the correct result you want, it's probably best to see which XML gets generated by APEX.
If the XML is correct, than it might be an AnyChart issue. If the XML is not correct, it's the way APEX generates it.
They way to work around that, is by generating the XML yourselves for ex. by a custom procedure.
Hope that helps