How to create formula using event and user property

  • 15 July 2022
  • 0 replies

Hi, I was wondering if anyone had any advice on creating a report for following:

  • Our users are grouped by an identifier called Account ID. Each Account ID has a property called User Count which is the maximum number of users that Account ID can have. 
  • I would like to see: out of the maximum number of users allocated for an Account ID, what’s the percentage that have logged in?

I think the solution would be to use the formula (A/B)*100, where
A - Total number of unique user logins with the Account ID
B - User Count property of the Account ID

I was able to add A; however, I’m unsure how to add B (the Account ID property) so that I can use it in the formula. Here’s a screenshot of what I have so far:


If anyone has any advice or suggestions it would be much appreciated. Thanks in advance!

0 replies

Be the first to reply!