I have a line chart with two series and I have a sorting issue when the data in the second series falls outside the boundary of the first.
For example, the blue line in this case represents the series with the smaller sequence value (10).
The red line is the second series with sequence 20, but the final two points a rendered on the far right, when really the belong on the far left, before the first blue data point - since they're in August 2014.
The problem is exacerbated when the order of the series is reversed. Note the dates on the x-axis.
Both SQL order by the date value.
The only reference on the forums I've found is this, with no outcome
Stacked Bar Chart with Multiple Series Sort Question
(Note the extended lines are thanks to ignore_missing)
This is on 4.2.0, but happy to reproduce on apex.oracle.com if people want to play.
Cheers,
Scott