Dashboards & Reporting

BWitcher
Participant

Overview of Weekly Deals Created

SOLVE

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.

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Overview of Weekly Deals Created

SOLVE

Hi @BWitcher,

 

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

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

3 Replies 3
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Overview of Weekly Deals Created

SOLVE

Hi @BWitcher,

 

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

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

BWitcher
Participant

Overview of Weekly Deals Created

SOLVE

This worked, thank you!

paulschmidt
Contributor | Elite Partner
Contributor | Elite Partner

Overview of Weekly Deals Created

SOLVE

I understand the X-axis. What do you mean by trailing weeks? 

0 Upvotes