Reporting on Average Time in Lifecycle Stage

[KMoser317]

Hello,

I've recently created a calculated contact property called Time in SQL. It calculates the time between becoming an SQL and becoming the next stage in our process - Sales Working.

I'd like to create a report that shows me the average Time in SQL over time for all of our contacts.

Any ideas of how to do that? 

[karstenkoehler · Accepted solution]

Hi @KMoser317,

Happy to help!

Navigate to Menu > Reports > Reports > Create report > Single object > Contacts.

Then, under Filters in the top left corner, select your date range. To start, I'd recommend "Create date is all time".

Next, in the Data tab, find your calculation property.

In the Visualization tab, pick the Summary visualization, then drag and drop your calculated property into the Displaying area. HubSpot now gives you the option to choose from a few measure, this is where you select Average.

Here's an example with another number property:

Hope this helps!