The last one for 2023 is something I had on my mind for quite a while but never really got the time to do it: Creating a hierarchy filter in Tableau. Until recently, there was not much on this issue; at least not that I'd be aware of. The only one I remember to have... Continue Reading →
Automatically select the last day of a period in a natural date-hierarchy drill down
Somewhat akin to what I wrote about lately, today we will be focussing on a question that was raised in the forums today. The asking person wanted to use the natural date hierarchy drill down (i.e. using the little plus / minus icons on date fields) to drill from year to quarter, month etc. This:... Continue Reading →
How to evalute the drill down level in a hierarchy
For today we want to see if there is a way to evaluate the level at which our view is set. What do I mean by that? Assume this is our hierarchy: and the task is to know if we are drilled down to Category, Sub-Category or Manufacturer. For example, in this screenshot, we are... Continue Reading →
