Skip to Main Content
Forums

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!

Percent Graph Page item..?

ApexLearnApr 12 2018 — edited Apr 13 2018

Hi,

I have a page item "P1_DEPT".

pastedImage_2.png

I have a page item "P1_DEPT_GRAPH" which is of Percent graph type.

pastedImage_1.png

Which showing the percent graph based on the below query.

pastedImage_0.png

I want to show the percent graph based on the query given in the source section.

I tried to get the percent graph based on the query but unable to change the percent graph based on the graph.

How to change percent graph based on the query given in the source section...?

Means on change of P1_DEPT item, i want to change the percent graph P1_DEPT_GRAPH.

Example :

If the P1_DEPT value is 10 (dept no from the dept table) then percent graph display the graph based on the employee count from that emp of dept no 10, let us assume employee count is 3 then graph displays as below.

pastedImage_4.png

If the P1_DEPT value is 20 (dept no from the dept table) then percent graph display the graph based on the employee count from that emp of dept no 20, let us assume employee count is 60 then graph displays as below.

pastedImage_5.png

Please provide the suggestioin / solutions.

Thanks,

Hanu
This post has been answered by fac586 on Apr 12 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2018
Added on Apr 12 2018
#apex-discussions
5 comments
1,582 views