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!

Oracle APEX Combination chart - how to create dynamic series name, label and values?

user-9bof3May 8 2023 — edited May 8 2023

Hi Experts,

I'm trying to create combination charts where the series name, labels and values should be dynamic. As an example, I have created simple scenario on apex.oracle.com. Below is how the data looks:

TABLE: ACTUAL_GROWTH
select 
       FISCAL_YEAR,
       LOB,
       ACTUAL_GROWTH
from "ACTUAL_GROWTH" a

TABLE: TARGET_GROWTH
select 
       FISCAL_YEAR,
       LOB,
       TARGET_GROWTH
from "TARGET_GROWTH" a

Below is the combination chart displaying as Group 3, 4 and 5

Here I'm trying to achieve legends = Series Name (Generate dynamically instead of creating each series with hardcoded value as the data keeps growing for different years)
x-Axis = LOB = Label
Y-Axis = GROWTH = Values

Below are the credentials to login to apex.oracle.com:

Workspace: DEMOJMJ
Username: demo
Password: Change@2023

Appreciate any help on this.

Thanks,
Vasanth

Comments
Post Details
Added on May 8 2023
4 comments
1,264 views