Calculating Average Sessions per User with Specific Events

·

Hi, is there a way to count the avg number of sessions per users, including a specific event ?

Ezequiel V.
·
·
Hi Adele! Ezequiel here, solutions engineer at Bildug Data (Mixpanel Parter) I think this queries achieve what you are asking
🙌1
Adèle G.
·
·
Indeed thanks 🙏 And what about having the distribution of nb of sessions per user ? I am doing a distribution(distinct count of day(created_at)) as a proxy, is it possible to do the same but counting the session and not the days ?
Ezequiel V.
·
·
mmm I have been trying to create but couldnt find a better approach
Adèle G.
·
·
ok thanks 🙏
🙌1