I need to create a expression to insert into a label.
In this expression, i have to use this data:
Date/hour, ID_Path, Ignition
So what i need to do is:
I need to count the amount of downtime. It tells the time between ignition 0 (off) and the Ignition 1 (on) = date/hour(ignition 1) - date/hour(ignition 0)
The problem is I have several identical / different records.
Date/Hour,
Ignition
id_path,
2014-09-08 00:16:32.000
0
17215967
2014-09-08 00:36:42.000
0
17211123
2014-09-08 00:56:52.000
0
17204958
2014-09-08 01:17:01.000
0
17259288
2014-09-08 01:37:11.000
0
17258500
2014-09-08 01:57:21.000
0
17257560
2014-09-08 02:04:47.000
1
17257350
2014-09-08 02:05:12.000
1
17260469
2014-09-08 02:05:36.000
1
17259887
2014-09-08 02:05:54.000
1
0206088
2014-09-08 02:06:35.000
1
3348442
2014-09-08 02:08:29.000
1
15325993
2014-09-08 02:08:34.000
1
13646438
2014-09-08 02:08:46.000
1
3773396
2014-09-08 02:09:05.000
1
4473620
2014-09-08 02:09:16.000
0
6473289
2014-09-08 02:10:10.000
1
5172137
2014-09-08 02:10:27.000
1
9388413
2014-09-08 02:10:53.000
1
17259864
2014-09-08 02:11:24.000
1
17259854
2014-09-08 02:12:12.000
1
17261094
2014-09-08 02:13:03.000
1
17261092
2014-09-08 02:13:28.000
1
17261081
2014-09-08 02:14:04.000
1
17261068
I need to count the downtime of each ID_Path (to say the total downtime of everybody and the max downtime). The data is not sorted by id_path but by the Date / Hour in the file. So have no idea how to get the total downtime of all ID_Path and acquire the number of ID_Path bigger and less downtime.
