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!

Ordering x-axis with month in chart apex 5.1.4

JeanYves BernierJan 4 2018 — edited Jan 5 2018

Hi I created a chart in apex 5.1 with the folowing select from a view

SELECT

cacdeht\_mm,

cacdeht\_month,

cacdeht\_yyyy,

cacdeht\_tot\_keur

FROM

v\_cacdcl\_chart\_mensuel\_n0\_n1

WHERE cacdeht_yyyy = to_char(add_months(sysdate,-12),'yyyy')

order by cacdeht_mm

cacdeht_month is the result of a to_char(cdcl_dt_saisie,'month')

cacdeht_mm is the result of a to_char(cdcl_dt_saisie,'mm')

I made an order by cacdeht_mm and choose cacdeht_month for the Label

But the result when displaying the graph is that the month is ordered in alphabetic as shown below

How can I order it by the month janvier-février an so one .

Screen Shot 01-04-18 at 04.56 PM.PNG

Thanks in advance

Jean-Yves

This post has been answered by JeanYves Bernier on Jan 5 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2018

Added on Jan 4 2018

#apex-discussions

5 comments

1,096 views