HubSpot Ideas

C-Note

OR Filters for Reports

I really need the ability to create reports using OR filters instead of just AND filters.  For example, we use fields like AC1 and AC2 when a contact has multiple accounts.  When I create a report, I want to be able to see if there are customers with values in either of those fields, not just one or both.

130 Comentários
FerhatSF
Participante

I am now initiated to HubSpot CRM.

First Report. 60 seconds into my hands on experience. 

 

Yes, Sir. 

 

I need NO operator filtering.

 

             Field 1 is something 

             OR

            Field 2 is something else. 

 

Please! 

FerhatSF
Participante

Can someone volunteer to teach the rest how to do analytics without logical operators?

TheCopilot
Membro

+1 to this requirement

TheCopilot
Membro

Found a workaround!

 

Since lists have OR operators, create a list with the filter you want and create a report filtering anybody on that list ("List membership = true")

DPG
Participante

Thanks for sharing TheCopilot!

 

1) Can you share what HS plan you are on?   (We are on the most basic, & reports are not an option.)

 

2) Lists are only available for Contacts, not Companies, correct?

nicolasb
Membro

Please add this!

Jetthro
Membro

Hi Hubspot team, 

 

Have you created this feature yet? It would be really beneficial to have th OR filter. It's a very basic feature that will save us a ton of time. Please let me know what the status is on this product request. 

finn
Top colaborador(a)

+1

Lauren_Humphrey
Membro

Hey HubSpot, 

 

If you're going to have a CRM functionality, please make it usable. This feature is imperative for reporting. Data in a system is worthless without the ability to run valuable reports on it and make decisions. 

gtallai
Membro

I'm putting together my first "View" in Hubspot. I'm desperate to see that the "OR" condition is not availabe in Hubspot!

(I wanted to filter all the e-mail addresses that are owned either of my four country sales colleagues...)  

Please add this as soon as possible!

alexab
Membro

100% agree with all the comments.

 

The workaround that I've been using is creating a Contact or Company List to leverage the OR functionality and using that list as the basis for the reports with "List membership" Filter.  It's not ideal, but has helped me with many reports that I've needed this capability with respect to Contact and Company reports and dashboards.

 

Screen Shot 2020-09-08 at 6.18.43 PM.png

Flo_essentry
Membro

Could you ad this feature please superfast! It´s a gamechanger for reporting. Don´t know how everybody can work without it! 
Will there be an ()-Logic aswell? 

DanBrookes
Membro

I echo this - really need this function

micboc
Membro

Wow, I could not believe this was not already included. I am adding my vote to get "or" functionality into the next feature set. 

JonathanElkin
Colaborador(a)

+1. Very surprised that an OR filter is unavailable as a standard reporting option.

AriP
Participante

This feature is way over due, should have been implemented two years ago.

WimF
Membro

Realy waiting for this

gedleigh
Membro

Hey HubSpot!  Is this issue being resolved?  There are so many people asking for this and the last info I can see is that it is in planning in April 2020. Is there any news?

RSullivan
Membro

In my case, I'm looking to create custom views under Companies, Contacts or Deals.  When filtering, we absolutely need the OR logic when creating filters.  

SSundar
Membro

This is incredibly basic. amazing that Hubspot does NOT have this. really shows that this is an SMB product and not ready for bigger businesses