Launch, grow, and unlock your career in data

November 29, 2017

Workout Wednesday: Treemap Drilldown

This week's Workout Wednesday from Emma builds primarily on several previous challenges, primarily:

If you haven't done those weeks yet, I would highly encourage you to tackle those first. They build upon each other and make this week's challenge much easier.

As for week 48, Emma asked us to build this treemap:

Go to Emma's blog for the requirements. For me, this was pretty straightforward as I'd done the other challenges. The only part that tripped me up was the sorting of the States. Once I got that figured out, it all fell into place.

Good luck! Here's my viz:


  1. @EmmaWhyte and @VizWizBI
    I am able to recreate above treemap, but is it possible to drill down to one more level in this? E.g. I want to drill down to some locations inside each city. Is it possible to do this in a single sheet? I am struggling with this from past 2 days without any hint from any resource on the web. Can you please help me with this? Pleaaaaase, help me.