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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on May 8 2023
4 comments
1,033 views