i tried to build a pie-chart on a multiple-choice property, counting # of contacts of a specific phenomena, broken down by property value.
The problem is that the total #of contacts is obviously more than the true 100%, because contacts with 2 values selected count twice.
Is there a way to make them count just once, by defining a priority criteria or something, in order to reflect the true 100%?
Not that I’m aware of, unfortunately. There aren’t any specific settings to prioritize values or deduplicate by contact for multiple checkbox properties.
If you wanted the exact numbers by a rule you define, I’d recommend creating lists for each option:
List 1: is any of value A, is none of value B, is none of value C
List 2: is any of value B, is none of value A, is none of value C
List 3: is any of value C, is none of value A, is none of value B
You could then look at the list counts or create (separate) reports vizualizing the count of contacts per list.