I have an event that states the time a user spent watching a video. A user may have triggered several of those events per day if the user watched several videos. I’m trying to aggregate the events on a user level so that I can get a distribution of how long a user watches videos on average per day. I’m struggling to figure out how to aggregate the events for users.
Best answer by Saish Redkar
View original
+10
Hi
You can use the “Average of Property Value” metric to get the average duration per day as seen in this demo chart -https://analytics.amplitude.com/demo/chart/new/tdo4rzkg
This will show you daily average of the duration property across all users during that day.
You can further use a group by on User ID to see the averages of individual users or filter on a given User ID.
Let me know if I understood your use case correctly. Hope this helps.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.