Reputation: 11

Oracle Apex - change chart label

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)?

Upvotes: 1

Answers (1)

Reputation: 5035

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

This is the behaviour in Oracle JET charts from 5.1

Upvotes: 2