Hi,
I have a small requirement. I have the below table of just Timestamp and value. Want to calculate the highlighted column. in script
TImestamp | Value Duration
3/18/2019 11:08:00 10 -
3/18/2019 11:08:01 111 1 sec
3/18/2019 11:08:02 121 -
3/18/2019 11:08:03 70 -
3/18/2019 11:08:04 122 2 sec
3/18/2019 11:08:05 1000 -
3/18/2019 11:08:06 1118 -
Basically wanted to calculate Highlighted Duration - Interval of Timestamp from start to end timestamp whenever value is greater than 100.
Thanks,
Garry