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 5.1.4 - Jet Chart issue - combination multi y-axis

Steve HarropFeb 17 2018 — edited Feb 19 2018

Hi,

I hope someone can help me with Jet Charts in the 5.1.4 release of Apex...

My Oracle production database cloud has just been upgraded to 5.1.4 and my Pareto charts are now broken.

My problem is is with combination charts with:

  • 2 series with specific orders
  • multiple y- axis
  • x-axis that is Text and not a date or timestamp

They now look like this:

pastedImage_1.png

The x-axis is text and I do not want this to be order alphabetically but based on the SQL within the series

There are 2 series - bar and line - and both these series are presented in a specific, matching, order but this version of Jet Chart appear to order the x Axis alphabetically.

The SQL for the series is like:

select NULL LINK,QUESTION_TEXT ,BAR_VALUE
from TABLE_A
order by ORDER_VALUE

select NULL LINK,QUESTION_TEXT ,PERCENTAGE_VALUE

from TABLE_A

order by ORDER_VALUE

and would present the data in exactly the same order.

Is there a way to make Jet Chart display the series in the specified order - this was working previously and looked like this:

pastedImage_6.png

If not, I will need to head back to AnyChart or find another workaround....

All help really appreciated.

Thanks

Steve

This post has been answered by Oleh Tyshchenko on Feb 19 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2018
Added on Feb 17 2018
7 comments
1,979 views