I have a report where we track total attendance (contacts) to a specific event. Sometimes these contacts change companies which is what I think is throwing off my report. Do you have any idea how I can dedupe the contacts in the report?
Here is a small snapshot of my colleague showing 2x some ohter contacts are showing 3-4x. It’s duplicating because he has two different companies under Record ID - Companies. Is there a filter where I can only show Primary Company or most recent company?
Hi @AMatalia
What data sources have you selected for the report.
If the same contact shows up for two different companies is because the contact is associated to more than one company.
Any reason you are not simply using contacts as primary data source that would only show one contact. Depending on how the report is build you can also add association label filters at the data source selection step of building a report.
Frank
Hey @AMatalia - thanks so much for posting in the Community!
@franksteiner79 is correct here - we’d expect to see those contacts more than once if they’re associated to more than one company and you’re using Companies as a data source in the report.
Looking forward to learning more about your setup per Frank’s reply to see what may be possible here!
Shane, Senior Community Moderator
