November 17, 2020
How to Create a Single Column Hierarchy Drill Down Drill Up with Parameter Actions
bar chart
,
beginner
,
boolean
,
drill down
,
drill up
,
fundamentals
,
header
,
hierarchy
,
how to
,
parameter
,
parameter action
,
set
,
set action
,
tableau
,
tip
,
trick
No comments
Twice recently I've used parameter actions to create a single column drill down and drill up to mimic a hierarchy.
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!
Subscribe to:
Post Comments
(
Atom
)
No comments
Post a Comment