APEX

G'day all,

After reading Hilary's comments in these posts, I was a little surprised to find us struggling with data densification behaviour in 5.1.3.

(I was looking forward to not including outer joins to small sets of months)

Oracle APEX 5.1 stacked bar chart

The release notes in both 5.1.3 and 5.1.4 state the following

8.1.4 JET Chart Data Densification

Oracle JET requires that each series of a multi-series chart contains a data point for each label that is represented on the x-axis. Otherwise, the multi-series chart may not render correctly by Oracle JET. Prior to release 5.1.3, the user was required to handle the densification of their data in their chart SQL query to ensure that each series had the same number of data points, even if they were null or zero. Oracle Application Express release 5.1.3 now includes support to automatically fill in gaps, injecting missing data points for multi-series charts.

I created the following tables, where sales is complete for the year, and budget only has data for the last half of the calendar year (lucky it's january)

create table data_sales as

select adD_months(trunc(sysdate,'mm'),-rownum) mth, round(dbms_random.value(70,100)) val

from dual connect by level <= 12;

create table data_budget as

select adD_months(trunc(sysdate,'mm'),-rownum) mth, round(dbms_random.value(70,100)) val

from dual connect by level <= 6;

select * from data_budget

Then I create region

Region Type: Chart

Type: Line

Time Axis Type: Enabled

And add the SQL for the two series

Here is the result in 5.1.4 - as expected

And in 5.1.3, the months in the second series have been erroneously transposed.

Reversing the series in 5.1.4 is fine, but in 5.1.3 it's... demon spawn.

We certainly need to get our ordering right.

Is the fix in 5.1.3 or 5.1.4?

Or have I missed something.

Cheers

edit: changed subject to include 18.1