Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex Line Chart Multiple Series

HelgaFourieApr 16 2014

I am using apex 4.2.3, and am having trouble displaying multiple y-axes correctly.

Scenario:

I have "x"-number of Nodes to plot (between 1 and 16), of which I plot the "Volume" and "% of Total" per 15 minute interval.  In order to retrieve the "x"-number of nodes, I have created a DB Function which builds my PIVOT SQL query dynamically (depending on the input value from the user).

I add the "Volume" to "series 1" and "% of Total" to "series 2" since the series scaling differs.  E.g. "Volume" could be between 0 and 6000 and "% of Total" could be anything between 0 and 100. I have updated the Chart to display 2 Y-Axes.

My Question is:

I have picked up that the displaying of the second series (in this case, "% of Total")  is not always plotting the series together on the graph with the scale 0 - 100, but adds it to the scale 0 - 6000.  Is this a "known error" with AntCharts?

I have used the custom XML-chart option as well, but since I have so many lines to plot, the #DATA# field is sometimes too small to return all data. I have even tried to concatenate 2 #DATA# fields, but Apex didn't recognize this.

Please assist.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 14 2014
Added on Apr 16 2014
0 comments
1,101 views