Count of Deals that have entered each stage weekly over the last 4 weeks

Smart CRM & Sales Hub Dashboards & Reporting
, ,
1

Hi,

I want to create a report, which is a table of the last 4 weeks and has the count of deals that have entered any of three stages (“Signed”, “Account live” & “Closed Won”).

I have almost created what I would like, but it’s not quite correct.

DShute_0-1754388282892.png
DShute_0-1754388282892.png1540×604 101 KB

Above, is what I’ve got currently. I have filtered for the Dates of the stages being entered being less than 31 days ago. I understand that the first date 2/6/25, is being populated because a Deal had entered “Account Live” on 23/07/25, but that Deal had entered “Signed” on 5/6/25.

DShute_1-1754388456082.png
DShute_1-1754388456082.png1207×104 15.6 KB

However, what I would like to see is this:

DShute_0-1754388953871.png
DShute_0-1754388953871.png1227×339 30.4 KB

Please excuse the rough edit, and hopefully what i’m asking for makes sense.

I guess that what I’m asking is if there is anyway of just having weeks as rows, that aren’t affiliated with an actual date on the deal. Because ultimately that’s where the issue lies

2

Hi @DShute
Thank you for posting to the Community!
I’d like to tag in some of our awesome Community Champions to take a look here - @johnelmer @louischausse and @OPerek-Clark do you have any input on this one?
-Cassie
Community Manager

3

Hey @DShute ,
The reason why your table is pulling in the wrong week rows.

Right now, your Rows are driven by "Date entered 'Signed'" which means HubSpot is showing the earliest of the three stage dates for that deal. So if a deal entered Signed back in June but moved to Account Live last week, your report still lists it under the June week.What you actually want is:

  • Rows that represent calendar weeks for the last 4 weeks.
  • Counts of deals that entered any of the three stages during each week.
  • A week to appear even if no deals entered a particular stage that week.

The challenge is HubSpot’s report builder doesn’t let you create a “generic week” dimension independent of a property every row grouping comes from a date field.

Use three separate reports + “Combine” dashboard

If HubSpot’s calculated fields aren’t available:

  1. Build three separate weekly reports:
    • Deals that entered Signed in last 4 weeks.
    • Deals that entered Account Live in last 4 weeks.
    • Deals that entered Closed Won in last 4 weeks.
  2. Group each by Week (from that stage’s date field).
  3. Put them on a single dashboard side-by-side so visually they line up by week.
4

As I thought, thanks for confirming.