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!
Solved
Aggregate event properties
Best answer by Saish Redkar
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.
+10Hey
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.
+8Hi
Glad to see this was solved by our power user
Kind Regards,
Denis
Reply
Welcome to the Amplitude Community!
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're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
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.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.