Hi all,
In Apex 21,2
I would like to show a graph with the last 12 months of production.
This is my query:
select null,
sum(f.comision) value,
TO_CHAR(f.efectiva,'Mon') label
from risk_facturas f
where f.efectiva >= add_months(trunc(sysdate), -13) and f.efectiva < trunc(sysdate) + 1
and f.organizacion_id = :APP_GET_ORGANIZACION_ID
group by TO_CHAR(f.efectiva,'Mon')
This is the graph am getting:
Two questions:
The graphs is not showing all 12 months. Is truncating the graph and shoing only six months even when I have nothing in Maximum Width of the graph.
How can I get the months in order?
Thanks for the help!
Javier