cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Downtime by timestamp and binary status

Highlighted
Moonstone

Get Downtime by timestamp and binary status

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 

1 REPLY 1
Highlighted

Re: Get Downtime by timestamp and binary status

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.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!