Hi, assume I have the following type of data for pressure sensors in multiple sites. What we need to do (preferably without using transactions) is calculate the duration for a site, UID when the pressure value drops below say 3 as a threshold. Any help or ideas appreciated.
Date Time Site UID Pressure
01/02/2017 12:01:00 abc 123 3.2
01/02/2017 12:02:00 abc 123 3.1
01/02/2017 12:03:00 abc 123 3
01/02/2017 12:04:00 abc 123 2.9
01/02/2017 12:05:00 abc 123 2.9
01/02/2017 12:06:00 abc 123 3.2
01/02/2017 12:07:00 abc 234 3
01/02/2017 12:08:00 abc 234 2.6
01/02/2017 12:09:00 abc 234 2.6
01/02/2017 12:10:00 abc 234 2.5
01/02/2017 12:01:00 def 123 3.2
01/02/2017 12:02:00 def 123 3.1
01/02/2017 12:03:00 def 123 3
01/02/2017 12:04:00 ghi 123 2.9
01/02/2017 12:05:00 ghi 123 2.9
01/02/2017 12:06:00 ghi 123 3.2
01/02/2017 12:07:00 ghi 234 3
01/02/2017 12:08:00 ghi 234 2.6
01/02/2017 12:09:00 ghi 234 2.6
01/02/2017 12:10:00 ghi 234 2.5
01/02/2017 12:11:12 ghi 234 3
01/02/2017 12:12:22 ghi 234 3.1
01/02/2017 12:13:12 ghi 234 3.2
02/02/2017 10:12:12 ghi 234 2.9
02/02/2017 10:13:12 ghi 234 3
02/02/2017 10:14:32 ghi 234 31
... View more