# Reporting on Average Time in Lifecycle Stage **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** professional\ **Created:** [September 20, 2023, 6:13pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097 "2023-09-20T18:13:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![KMoser317](https://avatars.discourse-cdn.com/v4/letter/k/b19c9b/32.png) [@KMoser317](https://community.hubspot.com/u/KMoser317)\ **Post date:** [September 20, 2023, 6:13pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/1 "2023-09-20T18:13:17Z")
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? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [September 20, 2023, 6:21pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/2 "2023-09-20T18:21:52Z")
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: ![karstenkoehler_0-1695234154216.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/a/4acd882fb4302fe302d0cba881aa307653f55b3b.png) Hope this helps! ---
**Author:** ![SSanborn](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@SSanborn](https://community.hubspot.com/u/SSanborn)\ **Post date:** [April 15, 2025, 10:48pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/3 "2025-04-15T22:48:47Z")
It seems that the average is no longer available ---
**Author:** ![GSnow7](https://avatars.discourse-cdn.com/v4/letter/g/90db22/32.png) [@GSnow7](https://community.hubspot.com/u/GSnow7)\ **Post date:** [February 2, 2024, 12:17pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/4 "2024-02-02T12:17:11Z")
@karstenkoehler You didn’t really answer the question. You showed him how to set the report up, but not specifically how to report on the length of time a contact is in the lifecyclestage. I also want to do this. I want to report on how long the contact is in each lifecyclestage, but there does not appear to be a proprty to do this. I can do Cumulative time in “lead” etc, but that’s not going to work. Essentially what I want is a graph like this: ![GSnow7_0-1706875978973.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/1/b1e223d958b91fc98975cbd929f69beb6dda792c.png) So I can set a benchmark, targets and monitor performance. Do I need to create properties and calculatons, if so how? ---
**Author:** ![JWestover](https://avatars.discourse-cdn.com/v4/letter/j/e47c2d/32.png) [@JWestover](https://community.hubspot.com/u/JWestover)\ **Post date:** [May 22, 2024, 9:13pm UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/5 "2024-05-22T21:13:42Z")
@GSnow7 Not sure if you solved this at all or not, but the way to get this is as you started on below. You need custom-calculated properties for each lifecycle stage that is taking into account the time from one stage to the next. This one shows you velocity trends for lifecycle stages across created dates for contacts. ![Screenshot 2024-05-22 at 3.12.37 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/b/8b6096f4880cd5113ea7a7afdff168a8d7ede748.png) ---
**Author:** ![GSnow7](https://avatars.discourse-cdn.com/v4/letter/g/90db22/32.png) [@GSnow7](https://community.hubspot.com/u/GSnow7)\ **Post date:** [May 24, 2024, 10:25am UTC](https://community.hubspot.com/t/reporting-on-average-time-in-lifecycle-stage/90097/6 "2024-05-24T10:25:07Z")
Nice work. No I didn’t solve it. Love to know how you created the above graph. I discovered the HS property “Cumulative time in a lifecycle stage” is non zero only if they have left the stage … sort of annoying for the contacts still in the stage. I guess I need to create a function to calculate current date - date entered stage for contacts that haven’t left the stage. My custom function HS skills aren’t up to scratch for this yet.