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 →
