topic Re: HubSpot Report Logic Not Excluding Recent Donors in Dashboards & Reporting

HubSpot Report Logic Not Excluding Recent Donors

LV781 — Mon, 17 Nov 2025 21:55:20 GMT

I am trying to build a LYBUNT report in HubSpot using deals as donations. My goal is to include contacts who have at least one deal with a close date between 12> and <25 months ago, and exclude any contact who has a deal that closed within the last 12 months. I created two filter groups on Deal Close Date and used custom logic such as 1 AND NOT 2. However, HubSpot still returns contacts who have recent deals, as long as they also have a deal in the older window.

How can I configure the report builder so that any contact with a recent deal is fully excluded, even if another deal matches the older date range?

Re: HubSpot Report Logic Not Excluding Recent Donors

chighsmith — Mon, 17 Nov 2025 23:30:40 GMT

Hi @LV781,

I understand that you want to create a LYBUNT report in HubSpot that includes only contacts with deals closed 12–25 months ago and fully excludes any contact with a deal closed in the last 12 months.

I'd like to tag in some of our Top Contributors to see if they can offer any guidance. Hi @KTownsend @NicoleSengers and @ScottPennwood do any of you all have any ideas on this one?

Thank you!

Cassie, Community Manager

Re: HubSpot Report Logic Not Excluding Recent Donors

LV781 — Tue, 18 Nov 2025 22:05:14 GMT

Thank You.

Can you move this post to the correct group?