Dashboards & Reporting

SDalton7
Membre

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

Résolue

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 Solution acceptée
christopher-RVO
Solution
Conseiller clé | Partenaire solutions Diamond
Conseiller clé | Partenaire solutions Diamond

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

Résolue

@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


Voir la solution dans l'envoi d'origine

2 Réponses
franksteiner79
Conseiller clé

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

Résolue

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
Solution
Conseiller clé | Partenaire solutions Diamond
Conseiller clé | Partenaire solutions Diamond

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

Résolue

@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