I have this as the SQL, but the chart is only showing the most latest date and no other dates.
SELECT null,
a.CR_MDT_DT
, trunc(min(b.created)) AS DE1
, trunc(max(b.created)) AS DE2
, trunc(max(b.created)) - trunc(min(b.created)) || ' days'
AS Diff
FROM CR_MDT a
FULL JOIN CR_MDT_VERIFY b
ON a.CR_MDT_ID = b.FK_CR_MDT_ID
LEFT JOIN patient c
ON c.SOCRD_ID = a.FK_SOCRD_ID
LEFT JOIN PT_STUDY d
ON d.FK_SOCRD_ID = c.SOCRD_ID
WHERE a.CR_MDT_DT BETWEEN TO_DATE('01/01/2017', 'mm/dd/yyyy') AND TO_DATE('12/31/2017', 'mm/dd/yyyy')
GROUP BY
a.CR_MDT_DT
ORDER BY
A.CR_MDT_DT