Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Legend not good for a bar chart

Hi,

Under APEX 24.2 I have a stacked bar chart. The result is no good, I have made 2 series.

It display on the legend 2 and 31 but I would like to be displayed Adults instead of 2 and 31.

The series are :

select TO_CHAR(trunc(date_reservation,'mm'), 'DD/MM/YYYY') month, SUM (VE_RESERVATION.NOMBRE_ADULTES) "Nombre d'adultes"
     from VE_RESERVATION where REGLE = 'Réglé'
    group by trunc(DATE_RESERVATION,'mm') order by 1

and :

select TO_CHAR(trunc(date_reservation,'mm'), 'DD/MM/YYYY') month       , SUM(VE_RESERVATION.NOMBRE_ENFANTS) "Nombre d'enfants"
     from VE_RESERVATION where REGLE = 'Réglé'
    group by trunc(DATE_RESERVATION,'mm') order by 1

The legend should be Enfants and Adulte.

Best regards.
This post has been answered by jariola on Mar 31 2025
Jump to Answer

Comments

Post Details

Added 3 days ago
#apex-discussions
8 comments
68 views