cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Registration open for Discovery Summit Europe. User Group Members benefit from a 25% discount with the code: DSEUgroup24
Choose Language Hide Translation Bar
danintel
Visitor

calculate time series

Hey how are you?
I need your help.

I have data of one of our valve.
When its open the value is 1, and when its close the value is zero.

I want to calculate the time it was close - at each session.
for example:
Between the last opening and the opening after that - 41 minutes passed.
That is, the valve was closed for 41 minutes.
What code can I write to calculate this?

Thank you!

1 REPLY 1
tom_abramov
Level V

Re: calculate time series

Hi,

I hope I understand the question.

Please see attached a data table with formulas - I think you dont have to use JSL in this case, just simple formulas in data table.

If I'm missing something, please attach your data.

 

BR,

Tom.