Hi,
My data looks like:
SiteID, Date, Time,DeviceID,Alarm
1234,01/01/2013,10:01,1,True
1234,01/01/2013,10:02,1,True
...
If a device is down for 10 min. I would see initial data msg and one msg every 1 min. until the device is up so I would see 11 msgs. There is no data message received when the device is up. When the device is up we would see a gap > 1 minute.
How can I calcuate downtime duration and downtime occurences count each month?
Regards
Martin
... View more