Average number of Sessions per User

Question & Answer
,
1

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 -

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

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

Any help would be appreciated!

2

Hi @Ops_Expert,

Can you try this instead?

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

It worked. Really straightforward :smile:

Thanks!!