Calculate time gap

[amiroh81]

Hello everyone

I have the following data:

user	First attampt	First Succsses	Delta (Min)
A	15/04/2018 09:13:18	15/04/2018 10:10:39	57
B	15/04/2018 09:10:26	15/04/2018 09:23:21	13
C	15/04/2018 12:26:08	15/04/2018 12:30:05	4

When I show the time that went from experience to success for a single user that is displayed correctly, I can not show the average time from the first attempt to the success for all users.

The problem is that First attampt and First Succsses is a measure that I am calculating:

First attampt - min(min_try_c)

First Succsses - min(min_seccuss_c)

Can anyone help?

Thanks in advanced

Amir

[YoussefBelloum]

Hi,

would you be able to attach sample data/sample app ?

[marcus_sommer · Accepted solution]

I think you need something like this:

interval(avg(aggr(min(min_seccuss_c) - min(min_try_c), user)), 'm')

- Marcus