Aggregate event properties

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!

Find more posts tagged with

Event

Event Properties

Accepted answers

Saish Redkar

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.

All comments

Saish Redkar

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.

Denis Holmes

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

Quick Links

Unanswered Questions

Error in Amplitude React Native SDK - "Cannot set property 'cookie' of undefined"
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…