Create "time in deal stage" report

[dwightbailey]

Can anyone help me? How do I create a report that looks like the below in Sales Starter:

[LRehn]

Hi! It's also possible to do your own solution using datasets if you have operations Hub.

I've made one for SQL date-> Close date using the "DATEDIFF" Function

[Hildegaard]

Please populate a today's date automatically

[SashaSalamandra]

@Jwyoung It only comes in a summarized data table view - so you can only see average time numbers summarized based on a date property. I  was looking for data split into individual deals but had no luck. 

[Jwyoung]

hi @karstenkoehler , same here... I don't have any deals popping up with the average deal time in a stage. Could you help us?

[Josica]

Hi @karstenkoehler , I've tried to create "Deal time spent in each stage" but no data was shown. Any Idea why is that so?

[WaqasNabi]

Hi @Josica ,

Here click the filter button on the top left corner. There choose the Pipeline, which data you want to show.

Hope it'll help.

[karstenkoehler · Accepted solution]

Hi @dwightbailey,

You should have this in your Report library. Navigate to Menu > Reports > Reports and click Reports library on the upper right. Search for "Deal time spent in each stage". (I had to filter the report library by deals first, using the sidebar, and scroll down a bit. The search doesn't work properly for me.)

I'm not sure whether you can further edit or customize the visualization of this report in Sales Hub Starter. I changed the frequency of my report from Weekly to Yearly.

Hope this helps!

[RPopovich]

Hi there, I am also trying to find this report and I am not seeing the report name: Deal average time spent in each stage. Does anyone know if this has changed? 

[PPlant4]

I don't have it either...so frustrating. 

[LRehn]

@RPopovich , @PPlant4 Im not sure about the out of the box report but it's very easy to build yourself using either single object och custom report builder. 

Since a couple months ago there were new properties created as default called "cumulative time spent in "deal stage X""

Have a look at the screenshot below! 🙂 

[VIyengar]

Hi Kevin,

I can't find this "Deal time spent in each stage" report anywhere. Has anything changed since your reply?

[kvlschaefer]

Hi @VIyengar,

Thanks for reaching out! 

The report is called "Deal average time spent in each stage" in my HubSpot portal. 

I was able to find it in the reporting library by navigating to Sales > Reports > Create Report and searching for "Deal Time Spent in Each Stage". 

Hope this helps!

Best,

Kristen

[RRichards]

This report appears to have been removed. What is the correct way to go about this at present?

[ASmolen]

It's now called "Deal average time spent in each stage"!

[annieg241]

I cannot find this in the reports library. Did they recently take it away?

[WaqasNabi]

It is available there. 

Select report library > from left filters select deals > then scroll down, you'll find it there.

[ASmolen]

I think it was just renamed to "Deal average time spent in each stage"