Following up on my >> previous blog post << I had the pleasure to virtually meet with Kirk Munroe and discuss the issues outlined in my posting. For those of you not yet familiar with Kirk, he is the author of "Data Modelling with Tableau." He is also a frequent guest on renowned Tableau blogs... Continue Reading →
Quickie: How to make a parameter “fire” on apply, not on change.
For today just a small tip on how to align your parameter changes and filters to all become effective on clicking the same button, like here: How to do this Parameters in Tableau allow the user to provide single values to their workbook. This feature enables interactivity in dashboards. It also allows for the dynamic... Continue Reading →
Filter a table w/o filtering
For this month's posting we will have a look at how to enable your users to "filter" columns from a text table without actually filtering it. Why would that be needed? Well one idea could be that you have one of these massive tables (you know, the ones you do not want to built but... Continue Reading →
Using a SET to Filter “and” condition
Recently on the forums a user asked how they could use a filter that was conditioned to imply "and" instead of "or" (factually I think Tableau translates any multi-select as an "in" clause like "where xyz in (....)" ). So, what did the user want to do? The requirement Let's have a look to better... Continue Reading →
Quickie: how often do our sales staff need more days than the allowed threshold between sales?
Heavens, time is flying by, isn't it? Already time for a new blog post. Since I am somewhat short on time these days, I just have a quick one to share. Assume your task is to provide your sales management with an overview that allows them to easily figure out how often it takes a... Continue Reading →
Hierarchy filters without data prep
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 →
A toggle without using paramaters
Usually, when using toggles, we refer to using parameters. However, it is also possible to create a toggle using a dimension and its two members (two because a toggle is either on or off, true or false, 1 or 0, A or B - or, you would have to "make it two" by whatever logic... Continue Reading →
How to do a count distinct over a rolling window
Recently a user on the forums asked how a distinct count over a rolling window could be done. Easy, you might say at first. Just use countd() and all be good. And that is true - and it is not. The problem we are facing here is that the usual countd() combined with say a... 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 →
Changing date granularity based on filter (!) selection
For today I have an interesting one. Let's assume we are faced with a request where the circumstances allow you to show a maximum of twelve bars in your chart. Reason isn't relevant, let's just stick with that as a prerequisite. At the same time, you are tasked to provide the most conclusive yet granular... Continue Reading →
Tableau Adventurer 