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 →
A(nother) quickie on bar chart labeling
A quick one for today. How do we get from this to this? There are several techniques and I have described one >> here << already but the one for today is this: add a secondary axis to your columns (sum(0)) Dual axis, synchronize create two calculated fields, one named "label +" the other "label... 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 →
Let’s build – fun with maps
In today's episode of "Let's build" we will create a dashboard (or: a sibling thereof) that I presented during our E&V Tableau Days 2023. Given that during that session I only had 35 minutes to do the data source prep and explanations, the calculations (20+) and then the actual dashboarding, I was a bit under... Continue Reading →
Let’s build – A dynamic table allowing your viewers to select the drill down dimensions
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 →
