Averaging event counts by a user property

  • 20 December 2021
  • 1 reply


Here’s my data setup - I have individual users A,B,C… who are taking many different types of actions on our product - each action is tagged as an event.

Each user is a “manager” who has a certain number of direct reports configured as a user property e.g. A could have 50 direct reports as a user property.

I now want to create a report where I can see a trend of “Count All Events” for each user - but I want to normalize that by the no. of direct reports they have i.e. I want to see the trend of “Count All Events” / No. of direct reports for  each user, and also aggregate that by client (which is a collection of users)

Anyone have any ideas on how to do this? All help appreciated!!





Best answer by mattvanwinkle 20 December 2021, 18:50

View original

1 reply

Userlevel 2
Badge +1

Hi @mridulganesh !  


Matt here.  How close does a report like this get you to your goal?:


This is looking at the average number of events per user broken down by the user property of “direct reports”.