Can't seem to figure out how to do an Average Per User

Question

I’m trying to capture averages per user across multiple accounts and found the below article, but the drop down for finding Average per user does not exist.

https://help.heap.io/chart-examples/engagement/see-the-average-event-count-per-user-over-time/

Analyze > Usage over Time > Graph (no option for Average per user)

icon

Best answer by Christy H 1 June 2023, 19:21

View original

Christy H · Accepted Answer

Hi @akitsen, In this case, this is the result of us testing some new functionality in Heap which not everyone hasaccess to quite yet. But no worries.In your account, you’ll want to achieve this by creating a Ratio chart.​​​​​​​You’ll want to start with aCount {Event Name} queryThen click Add RatioThen add a Count Unique{Event Name} queryClick View Results to get your desired output.Happy Heaping!!

akitsen · Answer

@Christy Hdang, I really wanted that feature.Maybe you can help me here then with this ratio thing, because it doesn’t necessarily easily accomplish what I’m after.Ultimately, I want the following:For Daily Active Users (DAU)Average count/number of times a particular event was triggered across all users by accountResulting in a row per account, with a sum average score of the event across all active users associated to that account.Mouthful but its what I’m after.