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?