L
Laoballer
I have data that's in this format
ID CREATION_TIME ARRIVED_TIME STOP_TIME
236286 12/18/2008 18:22 12/18/2008 19:02 12/18/2008 21:00
236294 12/18/2008 21:00 12/18/2008 22:45 12/19/2008 4:08
with this data I need to create a timeline/gantt type chart. with the
y-axis being the different ID number and the X-axis being time. I'm
thinking it would look like a stacked barchart with the creation_time
and arrive_time as one set of data and then the arrived_time and
stop_time being another set. Where each data set starts and end would
be the min and max of the x-axis. I've tried following some gantt
charting tutorials but I can't seem to get the charting correct.
Another problem I'm encountering is that the time duration of these
events could change, meaning the creation_time to arrived_time could
range from minutes to hours in duration or the duration from
arrived_time to stop_time could be minutes, hours, or days in
duration.
Thanks,
ID CREATION_TIME ARRIVED_TIME STOP_TIME
236286 12/18/2008 18:22 12/18/2008 19:02 12/18/2008 21:00
236294 12/18/2008 21:00 12/18/2008 22:45 12/19/2008 4:08
with this data I need to create a timeline/gantt type chart. with the
y-axis being the different ID number and the X-axis being time. I'm
thinking it would look like a stacked barchart with the creation_time
and arrive_time as one set of data and then the arrived_time and
stop_time being another set. Where each data set starts and end would
be the min and max of the x-axis. I've tried following some gantt
charting tutorials but I can't seem to get the charting correct.
Another problem I'm encountering is that the time duration of these
events could change, meaning the creation_time to arrived_time could
range from minutes to hours in duration or the duration from
arrived_time to stop_time could be minutes, hours, or days in
duration.
Thanks,