Interval with Inter-record function

[jrbrutto]

Hi all,

I have a question how to use Interval with inter-record function to calculate elapsed time between two timestamp.

Here the example I have a column with a date/time

I would to create a column about the elapsed time (hh:mm:ss) based on the next row like this

I tried Interval ( DatetimeField  - After(DatetimeField) , 'hh:mm:ss' ) as dimension. Expression is ok but it's an invalid dimension. How can make this works?

[sunny_talwar · Accepted solution]

May be try this

Aggr(
  Interval(DatetimeField - Above(DatetimeField), 'hh:mm:ss')
, (DatetimeField, (NUMERIC)))

[jrbrutto]

Great!!! It works perfectly. Thank you very much