OR Filters for Reports

+ 1, It would be a great feature!

+1 - only AND is really limited.

Adding our voice to this thread. Important capability. Surprising the report filter editor isn’t the same relatively advanced one as in views, where we do get access to “or”.

How is it possible to have a reporting tool without basic AND / OR logic options? If this was a free tool, perhaps it would be understandable… but as a premium paid tool, this is kind of absurd.

The HubSpot Product Team update is no longer available from 2020. However it says In Planning, has there been any updates?

The Custom Object Report has the OR functionality in setting up filters but the Single Object Report is still missing the OR functionality.

Single Object Reports give you more properties to reference (e.g. Date Entered Pipeline, etc) that are not available in Custom Object Reports.

Overall, HubSpot reporting feels clunky with the discrepancies between report types.

Echoing the sentiment 6 year later

Adding my vote for supporting “OR” logic in HS reports. In my case, I want to track the number of deals that enter any of 3 pipeline stages in a given time period. I have a few “AND” filters to choose the pipeline and the deal type and then I need a group of “OR” filters to collect deals from each of the pipeline stages, i.e.

  • Date deal entered stage 1 is last month
    OR
  • Date deal entered stage 2 is last month
    OR
  • Date deal entered stage 3 is last month

Yes, please! I just ran into this issue the other day and was surprised I couldn’t. Thanks for submitting! :grin:

Absurdly basic capability to still not be available and have no update from the product team for nearly four years.

I’ve been stunned by the reporting limitations in this product.

Jumping in to add a +1 to this, but also add a workaround that I discovered that worked for my particular scenario.

I was able to achieve the “OR” functionality that I hoped for by creating a report using “Custom Report Builder” instead:

Once I chose that option, I just chose a single Primary Data Source (in my case, “Deals”). Then, under the Filters there, you can select the “ANY” option, and start making Filter Groups.

This ended up achieving exactly what I was hoping for and had way more flexibility on top of that too. Just wanted to share in case this helps anyone else who was stuck like me!

@hubspot - Please consider adding this filter functionality to the Single Object reports as well.

Is this still really not a feature? Almost 4 years since it was “In Planning” but has dropped off? Such a basic reporting function seems logical.

I am just getting into reports after shelling out some pretty decent money for HubSpot.

No OR logic in filters for reports…what the??

Then I see this request started back in 2018.

Come on HubSpot!

Actually this can be done through the custom report builder now.

Hi everyone! I’m marking this as ‘Delivered’ because ‘OR’ filters are available with the Custom Report Builder. :slightly_smiling_face: