Is there a way to display average across a numerical event property?

Question

Hey everyone.I have an Event Property that tracks the # seconds it takes for some operation to complete by different users.I want to find the average # of seconds each user takes to complete this event every day.Is there a way to chart this?And if tracking this number via Event Property isn’t the way to do it, how can I accomplish what I’m looking for?Thanks!

Azu_Saucedo · Accepted Answer

Hi Lucy!If all you need is to get the property tracked average for that one event, there might be a few options. I will list them below and include the chart links to the Amplitude demo account!Average: using the group by function, you could create a chart that counts the average number of users who triggered the event by the seconds duration. I am not sure that this is what would solve what you are looking for particularly but could give you additional contexthttps://analytics.amplitude.com/demo/chart/new/kwo2vipiProperties: using the group by function of a numerical value (in your case, seconds), you could select the average of property value, however, this is going to give you the average for all the users, not per userhttps://analytics.amplitude.com/demo/chart/new/l2suey22If the two above are still not answering your question, you could refer to the custom formulas availablehttps://help.amplitude.com/hc/en-us/articles/115001163231If you don’t have a lot of users, you might be able to use a data table where you can add your metric (Dan shared a link to metrics FAQ) and group by user ID but, again, that is only if you have a small number of users. If it’s pruned, you could create segments instead where you group certain users and analyze their averages that way.Hope this helps!

dangrainger · Answer

Hi @Lucy. Sounds like a job for “Metrics”: https://help.amplitude.com/hc/en-us/articles/10249480038043

If you go to create a Metric, you can select the Property Average metric type, then plug in your event and the duration property you mentioned and you should be good. Note that your duration property will need to be integer.

Alternatively, do you have two events to measure the completion time between, or is it just a single event you capture with the lapsed time as a property? If you have two events, you can just create a Funnel with Event 1 > Event 2….in the table below the funnel you’ll see that you’re provided with “average time between”. You can also then change the funnel to show “time to convert” and you’ll get the distribution.

Hope this helps!