Dashboards & Reporting

BWitcher
参加者

Overview of Weekly Deals Created

解決

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 いいね!
1件の承認済みベストアンサー
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

Overview of Weekly Deals Created

解決

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.

元の投稿で解決策を見る

3件の返信
karstenkoehler
解決策
殿堂入り | Solutions Partner
殿堂入り | Solutions Partner

Overview of Weekly Deals Created

解決

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
参加者

Overview of Weekly Deals Created

解決

This worked, thank you!

paulschmidt
投稿者 | Elite Partner
投稿者 | Elite Partner

Overview of Weekly Deals Created

解決

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

0 いいね!