Try this
Number of regular users (login >=5 times)
... event=login| stats count by user | where count>=5 | stats count as "Number of regular users"
Number of open_page events done by regular users
To list regular users with corresponding open_page events
... event=login OR event=open_page | chart count by user event | where login>=5
To list total count of oepn_page events by regular users
... event=login OR event=open_page | chart count by user event | where login>=5 | stats sum(open_page) as "Total open_page events by regular users"
Proportion of close_page per user type (regular vs occasional)
... event=login OR event=close_page | chart count by user event | eval user_type=if(count>=5, "regular", "occasional") | eval temp=1 | chart sum(close_page) over temp by user_type | eval "Close_page Ratio(regular/occational)"=regular/occasional
... View more
