Is there a way to show a report that has x-axis as "number of deals created into a specific stage for the week" and then y-axis "trailing weeks." Would like to see in graph form how much each week has netted us.
In other words, you'd like to see how many deals enter one specific stage over time, broken down by week?
If so, this is easily created. Navigate to Menu > Reports > Reports > Create report > Single object > Deals.
In the Filters section (top left), change the Create date filter to another property. Search for "Entered Stage Date -" and find the stage you're interested in.
Next, click Hide filters and you should land in the Data tab. In here, click Add deal property and find the same "Entered Stage Date -" field.
Next, move on to the Visualization tab, drag and drop the "Entered Stage Date -" property into the Displaying area, along with Count of Deals. Change the bar type to vertical bar chart and use the Frequency dropdown in the top right corner to set it to Weekly.
That should be it. If you meant something else, let me know.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
In other words, you'd like to see how many deals enter one specific stage over time, broken down by week?
If so, this is easily created. Navigate to Menu > Reports > Reports > Create report > Single object > Deals.
In the Filters section (top left), change the Create date filter to another property. Search for "Entered Stage Date -" and find the stage you're interested in.
Next, click Hide filters and you should land in the Data tab. In here, click Add deal property and find the same "Entered Stage Date -" field.
Next, move on to the Visualization tab, drag and drop the "Entered Stage Date -" property into the Displaying area, along with Count of Deals. Change the bar type to vertical bar chart and use the Frequency dropdown in the top right corner to set it to Weekly.
That should be it. If you meant something else, let me know.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer