Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 518
0 REPLIES 0
Top Labels in this Space
Top Solution Authors