Interval between Timestamps in one field?

[OS92]

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 

[tresesco]

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

[OS92]

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

[tresesco · Accepted solution]

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.