Breaking Down Average User Engagement by Duration Intervals
Hello everyone, here is a simple question I cannot solve. I've tried with the AI bots but it doesn't seem to return the right answer. I have an event called "content_played", each one includes an attribute named "played_duration" (mesuring the amount of time a user spent on a content). For knowing the average amount of cumulated time my userbase spent on my contents I did "Aggregate Property by users" > Average (Sum played_duration). What I need now is to break it down by group of average, to get that X users have a time spent between Y and Z, and so one for each interval. It's very important business-wise. But nothing really seems to be working. Thank you in advance !
