Hi All,
I'm creating a box plot chart in Apex to replace my old candlestick anychart.
I am using Apex 18.2.0.00.12 and Oracle version 18.3.
My original candlestick chart has a specific order by for the X axis:
However my new Box Plot chart won't honor the order by clause in the query and shows the values alphabetically:
Is there some setting I'm missing to stop this sorting alphabetically?
Here's code to create a box plot for testing:
select label,
value
from (select 'EART' label, 10 value
from dual
union all
select 'FLRG' label, 15 value
from dual
union all
select 'WLODG' label, 10 value
from dual
union all
select 'WALLG' label, 10 value
from dual
union all
select 'RFCVG' label, 10 value
from dual
union all
select 'FIXI' label, 10 value
from dual
union all
select 'CABI' label, 10 value
from dual
union all
select 'PCI1' label, 10 value
from dual
union all
select 'PCI2' label, 10 value
from dual
)
order by case when label = 'EART' then '1'
when label = 'FLRG' then '2'
when label = 'WLODG' then '3'
when label = 'WALLG' then '4'
when label = 'RFCVG' then '5'
when label = 'FIXI' then '6'
when label = 'CABI' then '7'
when label = 'PCI1' then '8'
when label = 'PCI2' then '9'
end
Thanks,
Kate