Hi,
I have a table, RELIABILITY, which holds data for part reliability, so it has the following columns:
REL_DATE,
PART_NO
MTBF
This shows the Mean Time Before Failure for a part. Data is put into the table when a part fails, so there is not necessarily data for every month for a part.
I want to create a line chart which shows this, with lines connecting the points.
The problem I have is that say I have the following data:
REL_DATE - 01-JAN-10
PART_NO - APART
MTBF - 10
REL_DATE - 01-MAR-10
PART_NO - APART
MTBF - 20
If I chart this, I get two points mapped correctly, but because there is no data for 01-FEB-10 it does not join the points up. Bear in mind this is a very simplified example.
Is there anyway to tell APEX to ignore the "null" data for 01-FEB-10, and join up the points for JAN and MAR, so that at FEB it the line would go through 15 for MTBF?
Ideally I want to be able to do this without having to calculate a dummy value of 15 for FEB, as I would rather not put a point there as there is no actual data.
Any ideas?
Regards,
Jez.