Hi, I wanted to know if I can get the average or sum of an event property for some users.
For example, if the event playSong has a property songDuration, i want to know the average song duration for a group of users.
Thank you!
Best answer by Saish Redkar
View original
+10
Hey
You can utilize the custom formulas feature to apply the desired formulas on your event properties in an Event segmentation chart.
Here is an example chart which visualizes the average song duration for the AmpliTunes demo environment using the PROPAVG formula - https://analytics.amplitude.com/demo/chart/new/wpg7xkm
You can also compute the property average using the Properties option in the Event Segmentation chart
Let me know if I have interpreted your use case correctly. Hope this helps.
+8
Hi
Glad to see this was solved by our power user
Kind Regards,
Denis
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.