Solved

Aggregate event properties

  • 24 January 2022
  • 2 replies
  • 73 views

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!

icon

Best answer by Saish Redkar 24 January 2022, 22:40

View original

2 replies

Userlevel 7
Badge +4

Hey @ncoen 
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.

Userlevel 5
Badge +2

Hi @ncoen ,

 

Glad to see this was solved by our power user @Saish Redkar ! Thank you, Saish! Your hard and tireless work is really appreciated! :)  

 

Kind Regards,
Denis

Reply