How can I chart this data

donkeyx

New Member
Joined
Aug 3, 2017
Messages
1
Hey guys,

I am having a little trouble working out how i can chart this data. Basically, i am wanting to see a timeline with runtimes for each of these file creations. I was thinking if there was some way to just have each line as an individual start..stop, with a connecting line, at the appropriate location on the chart that would be great.

So from below, I am just wanting to see when and how long each file creation takes and how many overlaps etc, to get a better idea of optimisations i can make.

I was guessing that the horizontal axis, might be the hours raged from first file to the last file i.e 1am, 2am ---> 8am? but really i am struggling to work out the best way to graph this data, and any help would be greatly appreciated.

------- data sample
runtime, start time, endtime, file name.
4.0 1900-07-28 01:08:25 1900-07-28 01:08:29 created_file_1
13.0 1900-07-28 01:08:29 1900-07-28 01:08:42 created_file_2
2.0 1900-07-28 01:08:42 1900-07-28 01:08:44 created_file_3
4.0 1900-07-28 01:08:43 1900-07-28 01:08:47 created_file_4
5.0 1900-07-28 01:08:44 1900-07-28 01:08:49 created_file_5
1.0 1900-07-28 01:08:47 1900-07-28 01:08:48 created_file_6
2.0 1900-07-28 01:08:49 1900-07-28 01:08:51 created_file_7
3.0 1900-07-28 01:08:51 1900-07-28 01:08:54 created_file_8
2.0 1900-07-28 01:08:54 1900-07-28 01:08:56 created_file_9
1.0 1900-07-28 01:08:56 1900-07-28 01:08:57 created_file_10
2.0 1900-07-28 01:08:57 1900-07-28 01:08:59 created_file_11
2.0 1900-07-28 01:08:59 1900-07-28 01:09:01 created_file_12
2.0 1900-07-28 01:09:01 1900-07-28 01:09:03 created_file_13
37.0 1900-07-28 01:09:03 1900-07-28 01:09:40 created_file_14
52.0 1900-07-28 01:09:40 1900-07-28 01:10:32 created_file_15
7.0 1900-07-28 01:10:32 1900-07-28 01:10:39 created_file_16
2.0 1900-07-28 01:10:39 1900-07-28 01:10:41 created_file_17
10.0 1900-07-28 01:10:41 1900-07-28 01:10:51 created_file_18
2.0 1900-07-28 01:10:51 1900-07-28 01:10:53 created_file_19
2.0 1900-07-28 01:10:53 1900-07-28 01:10:55 created_file_20
1.0 1900-07-28 01:10:55 1900-07-28 01:10:56 created_file_21
 

Forum statistics

Threads
1,085,581
Messages
5,384,574
Members
401,909
Latest member
dlo1503

Some videos you may like

This Week's Hot Topics

Top