Aggr function on total sum

[John-SSI]

Hi, i missing something here.

If i don't choose any user it will be like this:

If i choose a user  it will be like this

So i'm missing something here.

Here is the calulation:
=Sum(Aggr(Fabs(interval(above(Total Timestamp#(Date,'YYYY-MM-DD hh:mm:ss'))-Timestamp#(Date,'YYYY-MM-DD hh:mm:ss'),'hh:mm:ss')),Date))

(I do not have start and end time in the date, just calculating the duration between the transactions)
The value should be 04:53:52 Ahaz in the fisrt picture.

[robert_mika]

Could you upload your file?

[John-SSI · Accepted solution]

Hi, i found it so it's working now 🙂