Hi All,
I have below data for which i need to generate data missing between the dates till today so that we can plot historical chart on this. Appreciate any suggestion or solutions on the same.
Temp:
Load * inline [
CaseID, CompletedDate, Value, CDate, TestResult_PointID
233579, 18-Sep-2020, Passed, 18-09-2020, 786133
233579, 16-Oct-2020, Failed, 16-10-2020, 786133
233579, 03-Nov-2020, Passed, 03-11-2020, 786136
233579, 17-Nov-2020, Aborted, 17-11-2020, 786134
233579, 19-Nov-2020, Passed, 19-11-2020, 786134
];
