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 How to evalute the drill down level in a hierarchy

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 Pass me that SQL – using rawsql to unlock missing functionalities

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 Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification

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 Two quick ideas on reference lines

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 Combine dynamic zone visibility and user permissions to de-clutter your user interface