Need help figuring out how many deals passed through a lane in a period
Hi everyone, how are you?
I need your help with something here.
We have a pipeline in Hubspot to handle our sales leads. Basically, the lead enters this stage upon raising their hands, then he goes through some lanes, becoming a SQL, then becoming a SAL, then becoming a Customer.
What I am trying to put together is a report that shows me how many SQLs were created by week. So, basically, the chart should have:
- x axis: the date the user entered that particular lane
- y axis: how many users entered the particular lane that week
We need to show this even for leads that were lost or that are already advanced to further lanes.