How To create a Heatmap (choropleth map) with two layers?

Is it possible to make a heatmap with two different layers? I have a list of zip codes and a count for each one. However, these zip codes fall into one of two categories, indicated by a column in my table with a value of 0 or 1. I tried pivoting that column and creating a map. But this is what I got:


It seems that it should be a map with some zip codes painted orange and some blue (by what the map legend shows). But instead it just painted them all green. Ideally, I would want a gradient of colors for each type of zip, according to the size of its count (You know, like a heat map…) but on two different scales, depending on whether it’s a 1 or a 0 on the filter column.

0 3 1,394
3 REPLIES 3
Top Labels in this Space