Skip to Main Content

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!

Random Order by in a Pie Chart !

Ryansun-OracleJun 13 2013 — edited Jun 13 2013

4.2.1

Hi There,

  We have a pie chart which has select like

select null, '0-10' Days , count(*) from table

union

select null, '11-20' Days, count(*) from table

union

select null, '21-30' Days, count(*) from table

union

select null, '>30' Days, count(*) from table

The 3d pie chart was showing the slices is the correct order 0-10, 11-20, 21-30, >30 but now shows it in random order.

Any suggestions on how to get the order by working. I suspect since the Days column in the select is a Character column this issue is occurring, however, with the restrictions in the number of select items we can have in the Apex charts, was wondering how do you get the order by working?

Thanks,

Ryan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2013
Added on Jun 13 2013
2 comments
298 views