APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Order the Chart Labels and Series

Rakesh119Jul 31 2020 — edited Aug 2 2020

The query for which i am drawing the bar is ( I am using 20.1)

select TOWER LABEL,

PRIORITY SERIES,

count(*) VALUE

from PBI_PKE

where "sla_in_7days" = 'Yes'

group by TOWER, PRIORITY

order by decode(TOWER, 'LINUX', 1, 'WINDOWS', 2, 'OPENSTACK', 3, 'TOOLS', 4, 'AV', 5, 'READY', 6) ASC

and I get a bar chart as below

bar chart for label ordering.PNG

I want to do the following things

- I want to order the labels so that the order is Linux, Windows, Openstack, AV

- I want to order the series Critical, High, Medium, Low.

Thanks

Rakesh

This post has been answered by fac586 on Aug 1 2020

Jump to Answer

Added on Jul 31 2020

#apex-discussions

15 comments

1,833 views