topic Re: Interval between Timestamps in one field? in App Development

Interval between Timestamps in one field?

OS92 — Wed, 13 Jan 2021 11:34:53 GMT

Hello,

have anyone a solution for my problem? I have a field with timestamps and now i would like calculate the difference between timestamp 1 and timstamp 2. Further then the difference between timestamp 2 and timestap 3, ... and so on.

Example: Timestamp 1: 06:00:54 - Timestamp 2: 06:03:58 = Duration: 00:03:04

best regards

oliver

Re: Interval between Timestamps in one field?

tresB — Wed, 13 Jan 2021 11:53:02 GMT

And how would you like to see/represent the output? In a table with timestamp as a dimension, or ...?

Re: Interval between Timestamps in one field?

OS92 — Wed, 13 Jan 2021 11:57:25 GMT

sorry - in a table as a key figure or dimension.

Re: Interval between Timestamps in one field?

tresB — Wed, 13 Jan 2021 12:05:19 GMT

You can use expression like:

Interval( TimestampField - Below( totalTimestampField), <format>)

Below() could be above() based on your sort order. 'Total' would be required or not, you can check that.