Map by multiple criteria
I often have to pull data that must include both people in a given location and people that have a relation to a given even within that location even if they are outside that location.
I am holding an event in NYC
I want to send an invitation to people within X miles of the event and I want to send an invitation to anyone that has attended that event in the past, even if they live outside the radius that I set.
I need to run the radius report
Then I need to run the event report
Then I need to merge both reports
Then I need to remove the duplicates as sometimes (often) the people within the radius will have participated in the event in the past, so they show up in both data sets.