Dashboards & Reporting

DEvans48
Member

Filtering not working

SOLVE

I'm using the filter section, and it doesn't seem to be recognising the filters I'm putting on.

 

specifically

: # Primary Company

 

Then im using multiple companies to remove them from the list, starting with around 600 deals and over half of those are companies i dont want in ther

 

How many of these filters can be used?

because they seem like there not all workingHelp from hubspot.png

0 Upvotes
1 Accepted solution
franksteiner79
Solution
Recognized Expert

Filtering not working

SOLVE

Hi @DEvans48 

 

I'd say the filtering works, but the fact that you have added the additional company filters in the same filter group means one deal needs be associated to all those companies, which will not be the case. You can see in your screenshot the logic operator is AND when in fact it should be OR.

 

As a general rule of thumb, if you want to exclude a large number of individual companies it might be easier to create a company property and simple work with one filter on that property (e.g. if is set, or has a specific value, or not) rather than adding and excluding individual companies.

 

Hope that helps.

Frank

 

 

Found my comment helpful? Great! Please mark it as a solution to help other community users.


Frank Steiner

Marketeer | HubSpot Expert | CRM Consultant

InboundPro

Let's Talk About Your Project

View solution in original post

0 Upvotes
3 Replies 3
DEvans48
Member

Filtering not working

SOLVE

Working better like this, thanks

0 Upvotes
franksteiner79
Solution
Recognized Expert

Filtering not working

SOLVE

Hi @DEvans48 

 

I'd say the filtering works, but the fact that you have added the additional company filters in the same filter group means one deal needs be associated to all those companies, which will not be the case. You can see in your screenshot the logic operator is AND when in fact it should be OR.

 

As a general rule of thumb, if you want to exclude a large number of individual companies it might be easier to create a company property and simple work with one filter on that property (e.g. if is set, or has a specific value, or not) rather than adding and excluding individual companies.

 

Hope that helps.

Frank

 

 

Found my comment helpful? Great! Please mark it as a solution to help other community users.


Frank Steiner

Marketeer | HubSpot Expert | CRM Consultant

InboundPro

Let's Talk About Your Project
0 Upvotes
DEvans48
Member

Filtering not working

SOLVE
I will give this a go and see if thats a better way

0 Upvotes