Forum Discussion

mcmum01's avatar
mcmum01
Icon for Helper I rankHelper I
8 years ago

Custom Grouping of Zip Codes

Has anyone ever built a map with custom regions? I have a list of zip codes and the Metropolitan Statistical Area (MSA) that the zip code is a part of. I would like to create a heat map based on the ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mcmum01,

 

I am not very clear about what you said "What I would like is the full MSA highlighted, not the individual zip codes. This view eventually would be used to look at national level transactions and not on an MSA by MSA basis.". Do you mean you want the entire MSA to be highlighted when you click one Zip code which is belong to MSA? If so, I'm afraid this is not achievable.

 

Regards,

Yuliana Gu

mcmum01's avatar
mcmum01
Icon for Helper I rankHelper I
8 years ago

Below is some sample data and zip codes grouped by MSA. I could create a heat map and map the zip codes separately. What I would like to do is map the MSA by the zip codes in the MSA and have the heat based on the 2nd table. It would be no different than looking at sales by territory, or voters by district, as those are basically custom regions. I have zip codes that I would like to put into a "region" and my regions happened to be called MSAs.