Dashboards & Reporting

BWitcher
Participante

Overview of Weekly Deals Created

resolver

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 Avaliação positiva
1 Solução aceita
karstenkoehler
Solução
Membro do Hall da Fama | Parceiro
Membro do Hall da Fama | Parceiro

Overview of Weekly Deals Created

resolver

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.

Exibir solução no post original

3 Respostas 3
karstenkoehler
Solução
Membro do Hall da Fama | Parceiro
Membro do Hall da Fama | Parceiro

Overview of Weekly Deals Created

resolver

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
Participante

Overview of Weekly Deals Created

resolver

This worked, thank you!

paulschmidt
Colaborador(a) | Parceiro Elite
Colaborador(a) | Parceiro Elite

Overview of Weekly Deals Created

resolver

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

0 Avaliação positiva