Hello!
You must have one field with date. (to show this in single chart)
You can do it like this (make new field 'type' and use this field in expression (set-analysis) on chart):
TempTable:
LOAD * INLINE [
Creation_Date, Accounted_for, Incident_ID
22.01.2016, 26.01.2016, 56465
19.01.2016, 29.01.2016, 56450
17.01.2016, 01.02.2016, 56400
10.02.2016, 15.02.2016, 58001
16.02.2016, 01.03.2016, 58050
];
NoConcatenate
DataTable:
LOAD
Creation_Date as Date,
Incident_ID,
'Creation' as type
Resident TempTable;
Concatenate(DataTable)
LOAD
Accounted_for as Date,
Incident_ID,
'Accounted_for' as type
Resident TempTable;
DROP TABLE TempTable;
