In Reports > Dashboard. Click in Add Report, and filter by Deals.
In this section, u have many reports of deals, how "Deal totals by stage" or "Deal stage funnel with deal totals and conversion rates", and others reports.
I believe with Funnel with deals and conversion rate, is possible where you was lost the deals, to improve.
Did this post help solve your problem? If so, please mark it as a solution.
I sort of worked it out but it will only work once a deal moves into a non active deal stage.
So I did a workflow that updated the Last deal Stage property to whatever the current deal stage was but only using live stages in the dropdown. I used the enrollment as deal stage has been updated in the last 1 day and then did if/then branches to cover each stage. So for example if deal stage is Qualified update last deal stage to qualified. As long as you don't use the closed won or lost stages in the last deal stage properties it will work but only when it gets to one of those stages. Hope that makes sense?
In an ideal world i would have got it to work on historic deals but it doesn't so I still can't report on what I want. I have raised it with my Hubspot AM so if I get an answer I will let you know
I have tried to create a Last deal stage property but it appears as a number and does not copy properly the name of my deal stage as it is a radio select ?