Combine 2 reports

Smart CRM & Sales Hub Dashboards & Reporting
1

JSchmitz2_0-1741222251925.png
JSchmitz2_0-1741222251925.png2267×732 85.2 KB

Hello HubSpot community. I’m trying to build a custom report that combines the 2 reports shown. I would like to bar chart with a count of Deals created weekly combinned with a line chart that shows the accrual of total Deals created. Any ideas?

2

Hi @JSchmitz2,

Here’s what you need to set this up in the custom report builder: Create reports with the custom report builder

karstenkoehler_0-1741238046063.png
karstenkoehler_0-1741238046063.png315×670 43.4 KB

Chart settings:

196×726 36.9 KB

Best regards

3

Hi Karsten, thanks for your help! Your solution worked great but for some reason I’m not seeing all of our Deals. It seems like my chart is only showing Deals from one Owner. How do I change it to show all Deals? We have 20 Deals in our Pipeline.

JSchmitz2_0-1741305182277.png
JSchmitz2_0-1741305182277.png1607×791 48.8 KB

4

@JSchmitz2 can you please share a screenshot of your report filters?

5

Hi Karsten, I figured it out. For some reason Contacts was shown as the
primary data source even though I selected Deals when I created the report.
Not sure how that happened, any ideas?
Also, on a related note, can you point me to a HubSpot Academy course on
advanced reporting? I was a heavy HubSpot user several years ago and I’m
having a hard time coming back up to speed.
Thanks for your help!
Jeff