math.timeDelta

Overview


math.timeDelta calculates the change in time between adjacent data points in a data stream.

 


Syntax

=math.timeDelta([data stream], "unit")


where "unit" can be "ns", "us", "ms", "sec", "min", "hr", "day"

 


Example

data_stream values = (1, 2, 3) with 
timestamps (2017-06-13T15:48:05Z, 2017-06-13T15:48:16Z, 2017-06-13T15:48:21Z) 
(timestamp 1 and 2 are 11 seconds apart, timestamps 2 and 3 are 5 seconds apart)


=math.timeDelta([data_stream], "sec")


creates a new data stream = (11, 5)