Calculating Average number of days between sessions

Hello!

I’m pretty new to looker, so please bear with me!

I’m trying to calculate the average number of days between sessions/logins of users. The data looks something like this:
 

f216ee06-f07d-4ab9-81ed-6466968b6597.png

Where each row corresponds to a user.

As an example of the result I’d like for each row:
The result for Row 1 would be: 2
The result for Row 2 would be : 7/3 = 2.33, i.e (number of days w/ no sessions/ no. of groups of no session days).

How might I go about this in the table calculator?

Cheers!
 

0 0 417
0 REPLIES 0
Top Labels in this Space
Top Solution Authors