I would like to know how I could make a sum of (date row 0 – date row 1) + (date row 2 – date row 3) and so on… group by userId.
Please refer to the screenshot below, I want to sum the time between every APP_OPENED and APP_QUIT event for EACH different idUser that logs into the app.
Result must be something like :
idUser – diffTime
2cf3… – 25 seconds
504… – 50 secondes