Get Downtime by timestamp and binary status

[VaibhavShinde]

Hi , 

I am looking for Downtime calculation in hours, i have two columns in table where i am logging both Downtime and uptime as timestamp with their values 0 and 1. But i want to calculate it in hours , how can we get this using javascript or any twx functions? 

Thanks 

[PaiChung · Accepted solution]

Some wonderful folks have been working on stuff like this already, like FSU RTPPM and upcoming DPM etc.

But each of your entries will have an associated timestamp ... so you can do the 'hard lifting' with that information.

to work ahead of the count, every time a value changes, there is VTQ New and Old Value Time and Quality.

This allows you to convert your 1 / 0 directly into up time elapsed and down time elapsed which would make the aggregation really simple.