Hi,
I have a page with a graph type bar. It has two series on it. If I dispaly only one serie, the data is dispalyed in chronological order as the request indicates it :
select count(*),
to_char(trunc(date_fin_travail, 'MM'),'MON YYYY') "dATTE"
from dt_informatique
where travail_termine is not null and date_fin_travail is not null
and UPPER(prise_en_charge) = 'NAME1@COMPANY.FR'
group by prise_en_charge, trunc(date_fin_travail, 'MM')
order by trunc(date_fin_travail, 'MM')
So far so good. if I had a seconde serie like that, the chonological order is lost :
select count(*),
to_char(trunc(date_fin_travail, 'MM'),'MON YYYY') "dATTE2"
from dt_informatique
where travail_termine is not null and date_fin_travail is not null
and UPPER(prise_en_charge) = 'NAME2'
group by prise_en_charge, trunc(date_fin_travail, 'MM')
order by trunc(date_fin_travail, 'MM')
I am using APEX 19.2.
Regards.