Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be try this
Aggr(
Interval(DatetimeField - Above(DatetimeField), 'hh:mm:ss')
, (DatetimeField, (NUMERIC)))
May be try this
Aggr(
Interval(DatetimeField - Above(DatetimeField), 'hh:mm:ss')
, (DatetimeField, (NUMERIC)))
Great!!! It works perfectly. Thank you very much