June 22, 2017
Makeover Monday: Tiled Heatmap of U.S. Air Quality Levels
air quality
,
AQI
,
heat map
,
Makeover Monday
,
Matt Chambers
,
ozone
,
tile map
,
tiles
,
United States
,
USA
No comments
I was very interested in looking at state-level air quality and built lots of heatmaps and originally built them in a single worksheet using table calcs to sort out which states go in which columns and rows.
This didn't work for me, though, because it only helped me see the states alphabetically. It's much more intuitive if they are displayed geographically. An idea popped into my head...
I wonder if I can combine a heatmap that looks at daily max reading by state across all years with a tile map.
I quickly went to Matt Chambers' great post for how build tile maps added the secondary data source, blended it by state and replaced my crazy table calcs with a simple tile map view. What a fun exercise! I learned a ton and feel like I created a much more intuitive view. Does anyone recall every seeing a tiled heat map? Have I come up with a new chart type???
Click on the image for the interactive version. Note that the viz might be slow to load as it's displaying about 460,000 marks.
Subscribe to:
Post Comments
(
Atom
)
No comments
Post a Comment