Oracle Apex - change chart label

1
votes

I have a chart based on region classic report, with a column populated with number's associated to id's in a different table.

The chart shows the label like is inserted in the table(number), how can I show the representative name for the ID from the other table (text)?

enter image description here

Graphic/ Chart labels

1
sqloracleoracle-apex

1 Answers

2
votes

In the chart attributes, you can nominate which column in the SQL represents the label shown in the report.

select count(*) cnt
 ,emp label
 ,deptno series
from emp
group by emp, deptno

enter image description here

This is the behaviour in Oracle JET charts from 5.1