Skip to main content
V
VaibhavShinde16-Pearl
16-Pearl
August 4, 2020
Solved

Get Downtime by timestamp and binary status

  • August 4, 2020
  • 1 reply
  • 908 views

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 

Best answer by PaiChung

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.

1 reply

P
PaiChung22-Sapphire IAnswer
22-Sapphire I
August 5, 2020

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.

Terms & ConditionsAccessibility statement