Interval and Previous over dates

[John-SSI]

Hi, when i added more dates into my data i see that expression  calculate the time between day1 (last transaction) and day 2 (first transaction)

Se picture:

Expression:

Output:
LOAD*,
If(UserName = Previous(UserName), Time(Interval(Timestamp#(Tid, 'hh:mm:ss') - (Timestamp#(Previous(Tid), 'hh:mm:ss')), 'hh mm ss'), null())) AS Duration3

Resident AS
ORDER BY UserName, Date,Tid;
DROP Table AS;

How can i aviod that so each day starting (the first transaction) is 00:00:00

[robert_mika · Accepted solution]

Did you try to add IF statement to your expression?

[John-SSI]

Hi Robert, 

Do you mean something like this?
if(Duration <0,00:00:00, Duration )

🙂

[John-SSI]

Btw, it worked 😄