cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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.