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 create a multi-language help-overlay
Dashboards often come with supportive overlays that help users to better understand the charts, data or even insights they are looking at in order to make the most of the data provided (and eventually: to make the most of your work as the designer of the dashboard). Let us leverage the utility of these overlays... Continue Reading →
LODs, Row Level Permissions, Cross joins and potentially a whole lot of costs
Today I have something that is related to optimizing your dashboards and/or data source row level permission for cost savings and to raise awareness of something that maybe you are not really aware. We will be looking into the effects of using (table scoped) LODs in combination with row level permission filtering at the source.... Continue Reading →
Vizzies Awards 2023
#TC23 has come to an end and once again I am very humbled to have been nominated in two categories for the Vizzies 2023 awards. What makes me especially happy is that this year I was also listed - besides the more or less natural category of "Forum Fanatic" - in the "Best Content Creator"... 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 →
Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification
For today I have something hopefully interesting for many. A Waterfall chart is a quite common type of chart whenever we look at financial data but obviously can be used in many regards. In any case, it always does the same: it explains how we come from a starting reference to an end value by... 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 →
Combine dynamic zone visibility and user permissions to de-clutter your user interface
Here is a quick note on dynamic zone visibility and how you might use it to improve user experience apart from the obvious. So, DZV is new since 2022.3 and you can use it to show and hide for example sheets dynamically based on a condition. Some caveats apply though: Source: https://help.tableau.com/current/online/en-us/dynamic_zone_visibility.htm Showing or hiding... 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 