zip code heat map?

I've used scatter map for board reports and there are quite a few forum posts on it from a few years ago on getting it "right". Filter order is key (or was). I usually do a city scale one and then something at a country level.

There are a few design settings to fiddle with but the thing that took a while for me was the levels. As you’ll see there will be lots of post codes with a few tickets and few with a huge amount. You don't want the former to down or the latter. I would look at setting colours in conditional ranges (exponential?) to get the data vis right.

If it's a one off report then you could export a pivot table of data and use excel map chart.

I've used scatter map for board reports and there are quite a few forum posts on it from a few years ago on getting it "right". Filter order is key (or was). I usually do a city scale one and then something at a country level.

There are a few design settings to fiddle with but the thing that took a while for me was the levels. As you’ll see there will be lots of post codes with a few tickets and few with a huge amount. You don't want the former to down or the latter. I would look at setting colours in conditional ranges (exponential?) to get the data vis right.

If it's a one off report then you could export a pivot table of data and use excel map chart.