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!
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.
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?
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.