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!