topic Re: Propierties count by reports more than once - how to fix in Dashboards & Reporting

Propierties count by reports more than once - how to fix

NMilheiro — Thu, 09 Nov 2023 17:33:32 GMT

Hi everyone,

I'm very new to hubspot and reporting and I had to create a pipeline to measure the type of services each client has, that means I created custom properties where I have one for " countries" and then a list of options where you can choose more than one country ( USA, UK, JAPAN, BRAZIL, etc), the problem is, if I want a report to show me which deals have which countries, I will get a multiplied count of each deal, like so:

You can see hubspot counts 13 deals total, however the total of deals is 4. How can I fix this while still showing the percentage of presence for each country?

Thank you so much

Re: Propierties count by reports more than once - how to fix

PamCotton — Thu, 09 Nov 2023 22:24:45 GMT

Hello @NMilheiro thank you for posting in our Community!

Have you created a custom object pipeline? How is currently set up this report? What is the data filtered? Only countries? The more information, screenshots, and details you can provide, the better I can advise on the next steps.

To our top experts @GRajput, @deepikaverma, and @Franci any recommendations to @NMilheiro?

Thank you,

Pam

Re: Propierties count by reports more than once - how to fix

NMilheiro — Fri, 10 Nov 2023 09:27:36 GMT

Hi Pam,

Thank you so much for awnsering.

I use a regular pipeline with deals to "feed" the graph, and this is the data I'm using: Deal owner, Market/ country and then the count of deals. Please note that the "Markets Complete" property is a custom property of multiple checkboxes, which I believe might be the reason why it's counting duplicate deals.

I do need to find a way tho, to have a property that allows me to choose more than one market to the same deal and then report on it.

I hope this was clearer 🙂