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!

Bar Chart Labels Appear Twice

GUS CRIGHTON11 hours ago

Hi

Apex 24.2

I have a bar chart based on this sql

select count(b.USER_NAME) , a.APPLICATION_NAME
from APEX_APPLICATIONS a, BDV_DEV.APX_USER_ROLES b
WHERE a.APPLICATION_ID = b.APP_ID
and WORKSPACE = 'BDV_SCAN'
and a.APPLICATION_ID not in (162, 163)
group by a.APPLICATION_NAME
order by a.APPLICATION_NAME

I have set label as APPLICATION_NAME and values as count(b.USER_NAME).

When run the report, it shows the labels twice (see below)

Any ideas appreciated

Gus

Comments
Post Details
Added 11 hours ago
0 comments
13 views