Dashboards & Reporting

SDalton7
Membro

Count of closed won deals... (at that time)

resolver

Hi! I've got a graph with the (cumulative) Count of Closed Won deals by Country, monthly. It's great for seeing how many are closed won now but when a deal moves to Closed Lost, it takes it out of the graph. 

SDalton7_0-1690906776953.png
I want it to reflect how many deals were actually in closed won at that time, and only reduces the number where they entered closed lost (rather than it just looking like they were never even in closed won) 

Hope this makes sense, and thanks in advance for any tips

1 Solução aceita
christopher-RVO
Solução
Conselheiro(a) de destaque | Parceiro Diamante
Conselheiro(a) de destaque | Parceiro Diamante

Count of closed won deals... (at that time)

resolver

@SDalton7  I would recommend using the Historical Snapshots report under the Sales Analytics tool. 

 

  • Historical snapshots: this report shows the number of deals at certain points in time by category (e.g., deal stage, amount), depending on the tab you select.

 

If this post helped to solve what you were looking for, please mark this as an accepted solution. Happy HubSpotting!


Christopher Barnett - VP of Revenue at Aptitude 8


Exibir solução no post original

2 Respostas 2
franksteiner79
Conselheiro(a) de destaque

Count of closed won deals... (at that time)

resolver

Hey @SDalton7 

 

How/why would a closed won deal ever become closed lost? Usually either of those is the final step in a deal's journey. 

 

That aside @christopher-RVO's recommendation would give you that info.

 

Frank

Found my comment helpful? Great! Please mark it as a solution to help other community users.


Frank Steiner

Marketeer | HubSpot Expert | CRM Consultant

InboundPro

Let's Talk About Your Project
christopher-RVO
Solução
Conselheiro(a) de destaque | Parceiro Diamante
Conselheiro(a) de destaque | Parceiro Diamante

Count of closed won deals... (at that time)

resolver

@SDalton7  I would recommend using the Historical Snapshots report under the Sales Analytics tool. 

 

  • Historical snapshots: this report shows the number of deals at certain points in time by category (e.g., deal stage, amount), depending on the tab you select.

 

If this post helped to solve what you were looking for, please mark this as an accepted solution. Happy HubSpotting!


Christopher Barnett - VP of Revenue at Aptitude 8