Every now and then on the forums people are asking how they can provide their viewers at least to some degree the freedom to select the dimensions they (the viewers) want to make use of. Instead of just having the choice of seeing sales broken down by Category and Order Date, maybe they want to... 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 →
Pass me that SQL – using rawsql to unlock missing functionalities
Rawsql is - in my opinion - one of the most often overlooked little gems in Tableau. I do not really know why that is, maybe the descriptions look a little to programmy with the argument placeholders? Whatever the reason, this little exhibit hopefully will serve a little good to this topic. When to use... Continue Reading →
Two quick ideas on reference lines
Here are two quick questions that were raised recently, both regarding the use of reference lines. Question: How to create a custom reference line? In this case, the user wanted to show a median as a reference line but only for values that exceeded a certain threshold. So, in effect he had a bar chart... Continue Reading →
How to select the last day of a dynamic period in Tableau || Let’s have (a word about) date(s) (6/6)
For today, we will do a rather short quickie. Imagine you are tasked with providing a dynamic view that can alter between say weekly, monthly, yearly and you want to show always time-period end values. Create a string parameter and insert there whatever you need, for example the values outlined before. Then, create this calculation:... Continue Reading →
Tableau Adventurer 