# Combine 2 reports

**URL:** <https://community.hubspot.com/t/combine-2-reports/127427>\
**Category:** Dashboards & Reporting\
**Tags:** reports\
**Created:** [March 6, 2025, 12:52am UTC](https://community.hubspot.com/t/combine-2-reports/127427 "2025-03-06T00:52:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JSchmitz2](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@JSchmitz2](https://community.hubspot.com/u/JSchmitz2)\
**Post date:** [March 6, 2025, 12:52am UTC](https://community.hubspot.com/t/combine-2-reports/127427/1 "2025-03-06T00:52:56Z")

</div>

![JSchmitz2_0-1741222251925.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/2/a2e7b8bcf3840951fda735d726fe587e70e88caf.png)

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?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 6, 2025, 5:15am UTC](https://community.hubspot.com/t/combine-2-reports/127427/2 "2025-03-06T05:15:00Z")

</div>

Hi @JSchmitz2,

Here’s what you need to set this up in the custom report builder: [Create reports with the custom report builder](https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder)

 ![karstenkoehler_0-1741238046063.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/7/37a7bf211a1d4b5e63bf4189724dd9cf376848f5.png)

Chart settings:

 ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/b/ab21876d2b59a6a87349ffcca38eb524a3dee4d5.png)

Best regards

---

<div class="post-metadata">

**Author:** ![JSchmitz2](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@JSchmitz2](https://community.hubspot.com/u/JSchmitz2)\
**Post date:** [March 6, 2025, 11:53pm UTC](https://community.hubspot.com/t/combine-2-reports/127427/3 "2025-03-06T23:53:09Z")

</div>

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](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/c/bc08cbd26465a4450f96bdf84d2cb3b1c846d600.png)

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 7, 2025, 4:57am UTC](https://community.hubspot.com/t/combine-2-reports/127427/4 "2025-03-07T04:57:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JSchmitz2](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@JSchmitz2](https://community.hubspot.com/u/JSchmitz2)\
**Post date:** [March 7, 2025, 3:11pm UTC](https://community.hubspot.com/t/combine-2-reports/127427/5 "2025-03-07T15:11:20Z")

</div>

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