Dashboards & Reporting

charisch
Participant

Is there a way to count all the different values in a property?

SOLVE

Hi there! I would like to know if there is a way to count all the different values in a property. It would be even better is there is a way to visualise this as well. 
For example, for each company, there is a value "Country/Region". Is there a way to now the number of different countries?
Thanks!

1 Accepted solution
Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Is there a way to count all the different values in a property?

SOLVE

Hi @charisch 


There isn't a way, that I know of, to do this in HubSpot but it would be pretty easy to do in Excel if you export all records that have a value in the relevant property and use a COUNTIF formula or similar. 

 

Hope this helps.

Phil Vallender | HubSpot Website Agency

View solution in original post

3 Replies 3
KTotten
Participant

Is there a way to count all the different values in a property?

SOLVE

Really? So if you want to know how many companies are in european countries, you can't generate a report that shows France (10)  vs Germany (13) vs England (22) etc?

0 Upvotes
Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Is there a way to count all the different values in a property?

SOLVE

Hi @charisch 


There isn't a way, that I know of, to do this in HubSpot but it would be pretty easy to do in Excel if you export all records that have a value in the relevant property and use a COUNTIF formula or similar. 

 

Hope this helps.

Phil Vallender | HubSpot Website Agency
charisch
Participant

Is there a way to count all the different values in a property?

SOLVE

Thanks a lot @Phil_Vallender !

0 Upvotes