Hello,
thirst, I created an example application on apex.oracle.com to check if it's working with the newest APEX version. But it isnt't. I get the same behaviour like in our 22.x.
I have a table with year, month, quantum and costs. The chart should display the yearly costs grouped by quantum column and summarize the cost:
select * from (select level rn from dual
connect by level <= 12) lvl
left join(
select x.year, x.month, x.quantum, sum(x.QUANTUM_COSTS)
from cost x
where x.year = 2023
group by x.year, x.month, x.quantum
order by x.month
) c
on lvl.rn = c.month
order by lvl.rn;
In the classic report on top you can see that for “sg-transportation” and “cgi-std-case-qty” not each month is filled with costs. From the data that's ok. But when I do the same SQL code in the chart the values of the two names are sorted at the beginning of the chart (1. month) and not like expected 9. month.
My Chart attributes:
- Bar chart
- Stack enabled
- Stack Label enabled
- Fill Gaps in Chart Data disabled
My Series settings:
- Series Name = Quantum
- Label = RN
- Value = SUM(X.QUANTUM_COSTS)
X Axis Settings: all default
Y Axis Settings: Format = Currency
Any idea?