This is my first attempt at a chart using APEX 20.0. I am trying to generate a Line Chart single series for a 1 year date range. I have multiple values for the months JAN-2012 (2) and DEC-2012 (3). However, when I plot it, I noticed that the Line series is only plotting one value and pushing the next value to the next month.
JAN-2012 - Measures are 1.54 and 3.35 (Example, 3.35 is being plotted against 02-12 and not 01-12)
DEC-2013 - Measures are 1.54, 4.04 and 5.09 (Example: These are all being plotted outside the date range)
Scripts for Table creation and INSERT statements
CREATE TABLE LINE_SERIES_TB (REP_DATE DATE,
REP_DATE_LBL VARCHAR2(5 BYTE),
MEASURE NUMBER);
insert into LINE_SERIES_TB values (to_date('01-JAN-2012','DD-MON-YYYY'),'01-12',1.54);
insert into LINE_SERIES_TB values (to_date('01-JAN-2012','DD-MON-YYYY'),'01-12',3.35);
insert into LINE_SERIES_TB values (to_date('01-FEB-2012','DD-MON-YYYY'),'02-12',null);
insert into LINE_SERIES_TB values (to_date('01-MAR-2012','DD-MON-YYYY'),'03-12',null);
insert into LINE_SERIES_TB values (to_date('01-APR-2012','DD-MON-YYYY'),'04-12',1.99);
insert into LINE_SERIES_TB values (to_date('01-MAY-2012','DD-MON-YYYY'),'05-12',null);
insert into LINE_SERIES_TB values (to_date('01-JUN-2012','DD-MON-YYYY'),'06-12',1.54);
insert into LINE_SERIES_TB values (to_date('01-JUL-2012','DD-MON-YYYY'),'07-12',null);
insert into LINE_SERIES_TB values (to_date('01-AUG-2012','DD-MON-YYYY'),'08-12',null);
insert into LINE_SERIES_TB values (to_date('01-SEP-2012','DD-MON-YYYY'),'09-12',null);
insert into LINE_SERIES_TB values (to_date('01-OCT-2012','DD-MON-YYYY'),'10-12',null);
insert into LINE_SERIES_TB values (to_date('01-NOV-2012','DD-MON-YYYY'),'11-12',null);
insert into LINE_SERIES_TB values (to_date('01-DEC-2012','DD-MON-YYYY'),'12-12',1.54);
insert into LINE_SERIES_TB values (to_date('01-DEC-2012','DD-MON-YYYY'),'12-12',4.04);
insert into LINE_SERIES_TB values (to_date('01-DEC-2012','DD-MON-YYYY'),'12-12',5.09);
Is such a series not possible using Line Chart? Would this have to be Scatter?
January, 2012:
December, 2012:
