Skip to main content

Our users complete multiple actions during their sessions. We’re specifically looking to understand the time spent during one specific flow in the app, and there will be an event that is triggered when the user starts the flow (A), and another event will be triggered when the flow is completed (B). Both events will have an event property that logs the time the event was triggered at.

Is it possible to use the Formula feature to calculate the average time difference between the Event A and Event B’s respective event property that documents the event triggered time?

I understand that Session Analysis exists, but that seems like it focuses on overall sessions, but allows filtering based on if an event occurred. However, as I mentioned, Event A and B are likely to occur, along with a large list of other events. I only want to know the length of time between Event A and B.

Can formulas accomplish this? Is there any other feature in Amplitude that help me do this?

Hi Raga,

Thank you for reaching out! I understand you’re looking to calculate the average time difference between two specific events (Event A and Event 😎 based on their respective event properties that log the time they were triggered. Let’s explore how this can be achieved in Amplitude.

Currently, the Formula feature in Amplitude does not directly support calculating the time difference between two events based on their event properties. However, there are alternative approaches you can consider:


1.

**Time Spent Analysis**: Amplitude’s Time Spent Analysis feature allows you to measure the time between two events. While this is typically used for predefined session flows, you can configure it to focus on specific events like Event A and Event B. You can learn more about this feature here(https://amplitude.com/docs/analytics/charts/data-tables/time-spent-analysis). However, this is only available for customers on the Growth and Enterprise plans.



2.

**Funnel Chart**: This chart has _Time to Convert_ metric that shows you the time it took users to go from A -> B: https://amplitude.com/docs/analytics/charts/funnel-analysis/funnel-analysis-interpret#time-to-convert.



Hope this helps!

Best,
Eddie


P.S. Checkout upcoming events and user meetups on our events page.

Reply