i need to do multiple label for different series oracle apex bar chart.
I try to do sys sql code:
SELECT VALUE,
Series,
NAME,
LABEL
FROM (SELECT 2 AS VALUE,
'Plan' AS SERIES,
'Object0' AS NAME,
'15 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 1 AS VALUE,
'Fact' AS SERIES,
'Object0' AS NAME,
'15 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 1 AS VALUE,
'Plan' AS SERIES,
'Object1' AS NAME,
'15 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 1 AS VALUE,
'Fact' AS SERIES,
'Object1' AS NAME,
'15 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 1 AS VALUE,
'Plan' AS SERIES,
'Object2' AS NAME,
'16 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 0 AS VALUE,
'Fact' AS SERIES,
'Object2' AS NAME,
'16 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 3 AS VALUE,
'Plan' AS SERIES,
'Object0' AS NAME,
'16 week' AS LABEL
FROM DUAL
UNION ALL
SELECT 2 AS VALUE,
'Fact' AS SERIES,
'Object0' AS NAME,
'16 week' AS LABEL
FROM DUAL)
Output rezult:
1 Plan Object0 15 week
1 Fact Object0 15 week
1 Plan Object1 15 week
1 Fact Object1 15 week
1 Plan Object2 16 week
0 Fact Object2 16 week
1 Plan Object0 16 week
1 Fact Object0 16 week
sql query is parametric
Here is example what i meen on th eimage below.
