Dashboards & Reporting

rickgoz
Member

Meetings Count for Unique Company

SOLVE

Hi,

 

I am working on a chart to display the number of meetings per month. I need the chart to show the number of unique meetings per day per company, excluding instances where multiple contacts are present in the same meeting.

 

Currently, my chart is accurate except it counts meetings with multiple contacts more than once.

 

Thank you for your assistance.

Screenshot 2024-05-21 at 10.16.19.png

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Count for Unique Company

SOLVE

@rickgoz with the choice for contacts to be the primary data source, you're forcing HubSpot to count each contact. You would have to change so that activities are the primary data source.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
3 Replies 3
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Count for Unique Company

SOLVE

Hi @rickgoz,

 

Which data sources does your report have, which one's the primary? With sales activities as the primary and only source, for example, you shouldn't be seeing duplicates.

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
rickgoz
Member

Meetings Count for Unique Company

SOLVE

My Primary is Contact and then Activies and Companies

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Count for Unique Company

SOLVE

@rickgoz with the choice for contacts to be the primary data source, you're forcing HubSpot to count each contact. You would have to change so that activities are the primary data source.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes