https://community.hubspot.com/t5/Dashboards-Reporting/Create-deal-that-shows-deal-stage-and-number-of-tasks-open/m-p/1244210#M13475 <P>Hi&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/1035049">@RSergeant</a>,</P> <P>&nbsp;</P> <P>You would use the custom report builder for that:&nbsp;<A href="https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder" target="_blank">https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder</A></P> <OL> <LI>As data sources select Deals and Tasks</LI> <LI>Drag and drop "Deal stage" onto the x-axis</LI> <LI>Drag and drop "(Count) tasks" on the y-axis</LI> <LI>Apply a report filter for "Task status", assuming you want to filter out copmleted tasks</LI> </OL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="karstenkoehler_0-1769098418832.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/166521i518742FC168A177F/image-size/medium?v=v2&amp;px=400" role="button" title="karstenkoehler_0-1769098418832.png" alt="karstenkoehler_0-1769098418832.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="karstenkoehler_1-1769098424556.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/166522i685BC4EE63BB0004/image-size/medium?v=v2&amp;px=400" role="button" title="karstenkoehler_1-1769098424556.png" alt="karstenkoehler_1-1769098424556.png" /></span></P> <P>&nbsp;</P> <P>Best regards</P> Thu, 22 Jan 2026 16:13:52 GMT karstenkoehler 2026-01-22T16:13:52Z https://community.hubspot.com/t5/Dashboards-Reporting/Create-deal-that-shows-deal-stage-and-number-of-tasks-open/m-p/1244199#M13473 <P>Good afternoon,</P><P><BR />Could you please advise on how I would create a new report show the deal stage on X axis &amp; number of tasks open on Y axis.<BR /><BR />I would like to be able to get a list of closed deals (over a certain period of time) with tasks still open to be actioned.&nbsp;</P><P>&nbsp;</P><P>Thank you</P> Thu, 22 Jan 2026 16:03:04 GMT https://community.hubspot.com/t5/Dashboards-Reporting/Create-deal-that-shows-deal-stage-and-number-of-tasks-open/m-p/1244199#M13473 RSergeant 2026-01-22T16:03:04Z https://community.hubspot.com/t5/Dashboards-Reporting/Create-deal-that-shows-deal-stage-and-number-of-tasks-open/m-p/1244210#M13475 <P>Hi&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/1035049">@RSergeant</a>,</P> <P>&nbsp;</P> <P>You would use the custom report builder for that:&nbsp;<A href="https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder" target="_blank">https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder</A></P> <OL> <LI>As data sources select Deals and Tasks</LI> <LI>Drag and drop "Deal stage" onto the x-axis</LI> <LI>Drag and drop "(Count) tasks" on the y-axis</LI> <LI>Apply a report filter for "Task status", assuming you want to filter out copmleted tasks</LI> </OL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="karstenkoehler_0-1769098418832.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/166521i518742FC168A177F/image-size/medium?v=v2&amp;px=400" role="button" title="karstenkoehler_0-1769098418832.png" alt="karstenkoehler_0-1769098418832.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="karstenkoehler_1-1769098424556.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/166522i685BC4EE63BB0004/image-size/medium?v=v2&amp;px=400" role="button" title="karstenkoehler_1-1769098424556.png" alt="karstenkoehler_1-1769098424556.png" /></span></P> <P>&nbsp;</P> <P>Best regards</P> Thu, 22 Jan 2026 16:13:52 GMT https://community.hubspot.com/t5/Dashboards-Reporting/Create-deal-that-shows-deal-stage-and-number-of-tasks-open/m-p/1244210#M13475 karstenkoehler 2026-01-22T16:13:52Z