Hi All,
In Apex 20.1
I have this bar chart group by months.
The problem is that the months are in alphabetical order.
This is my query in the series:
select null,
sum(f.prima) value,
TO_CHAR(f.efectiva,'Mon YY') label
from risk_facturas f, risk_polizas p
where p.poliza_id = f.poliza_id
and f.efectiva between :P182\_DESDE and :P182\_HASTA
and (NVL(:P182\_ASEGURADO,'0') = '0' or :P182\_ASEGURADO = p.cliente\_id)
and f.organizacion\_id = :APP\_GET\_ORGANIZACION\_ID
group by TO\_CHAR(f.efectiva,'Mon YY')
How can I get the months in their regular order?
Any help will be appreciate it!
Javier