Do you want individual marks or simply color coded zip codes? You can use Groups to classify the zip codes into 6-regions. After doing so, you could remove Zip Code from the viz and this will automatically aggregate the zip codes into 6 marks.
Is there a Region field in your data? You could assign that the geographic role of Zip Code, and simply geocode based on "Region".
Any chance you could post your data?
Sorry for the late response, wrapped up in other things.
I need the 6 regions color coded, and ultimately what I need is to be able to use the map as a filter, so users can click on a region and have data filtered accordingly.
The problem I'm having is that the data is identified by region, not zip code. So I can import the zip codes categorized by region and make a nice region map, but when I try to merge this with my regional data, every case is multiplied across all the zip codes.
Here's the workbook:
BHS.twbx 63.8 KB
Did you try blending both sources and using an action filter ?
In you file there only the geographic data.