I have a event created each time a user does an action in my system (e.g. login, open_page, close_page).
I need to do statistics based on the user regularity: a regular user logins more than 5 times or more over a period, the others are occasional.
I use the query:
... event=login| stats count by user
which returns the following :
User A: 10
User B: 7
User C: 3
User 😧 5
I am trying to obtain the following:
Number of regular users (login >=5 times)
Number of open_page events done by regular users
Proportion of close_page per user type (regular vs occasional)
Thanks for the help!!
... View more