Launch, grow, and unlock your career in data

November 17, 2020

How to Create a Single Column Hierarchy Drill Down Drill Up with Parameter Actions

No comments

Twice recently I've used parameter actions to create a single column drill down and drill up to mimic a hierarchy. 

  1. HR Analytics KPI Dashboard (Viz • Blog post)
  2. Makeover Monday Week 46 (Viz • Blog post)

Many of the examples of drill down you've probably seen so far use either set actions or parameter actions to create an additional column. The drawback is that you end up with an extra column that only has values when you drill down.

In this example, I show you how to use only ONE column to mimic drill down / drill up functionality. In total, it requires 2 parameters, 4 calculate fields, and 2 parameter actions. I find this method much more intuitive to the user. 

Let me know what you think or how you put it into practice. Enjoy!

No comments

Post a Comment