Average number of Sessions per User

Hey QS experts,
I need to generate a KPI where I need to determine - “average number of Logins per user into system website”. I’m using this formula but it’s throwing an error -


EVENT_ID**: Character field. Each time a user logs in, an ID is generated

Any help would be appreciated!

Hi @Ops_Expert,

Can you try this instead?

avg(distinct_count(EVENT_ID, [{USER_EMAIL}]))

It worked. Really straightforward :smile: