Solved

Event count distribution by unique users

  • 28 July 2021
  • 2 replies
  • 1051 views

Badge

I’m trying to see a distribution (Bar chart) of the number of users who triggered an event: Zero times; Once; Twice; Three times; Four times; etc… for all valid number of events triggered by one or more users in the period.

So the result should show:

zero Times: 10 users

Once: 9 users

Twice: 4 users

Three times: 2 users

Four times: 1 users

 

Any ideas on how I could achieve this?

icon

Best answer by MikkoKarvonen 28 July 2021, 08:59

View original

2 replies

Userlevel 5
Badge +3

I’m not entirely sure what you mean by “for all valid number of events triggered by one or more users in the period”. Are you looking at individual events or all your events grouped in one?

For individual events you can get the distribution of users performing the event at least one easily by using the Frequency view in the event segmentation and switching to the Bar chart visualization.

If you absolutely need also the users who performed the event 0 times, you could set your cohorts up and query like this:

Note that this approach is using Uniques instead of Frequency.

If this does not cover what you are looking for, please provide bit more details.

Badge

Yip you nailed it thanks Mikko.

I would’ve liked to see zero times as well but not critical and the frequency view makes it really so I’ll roll with that.

Thanks again legend!

Reply