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 →
Fair cohort retention analysis
My today's posting is not only technical but a reminder to always think about what you provide when being tasked with something. Do not only technically solve something, make sure that it is logically viable. Imagine your superior comes to you and tasks you with the following. "We need to do a cohort retention analysis... Continue Reading →
A quickie on maps
For today I have just a super tiny tip. Sometimes, your dataset only consists of data like [city name], the [latitude] and the [longitude]. No further information available. If you put that on a map, Tableau will automatically draw the dots and the map in the background like this: That is ok but not really... Continue Reading →
How to put a ratio above a side by side bar chart built from two different measures
Today we are going to deal with a request that recently popped up during our work. The question was how to put a ratio above two bars from two different measures that are grouped by year. Like this: Either, there is nothing on this topic or we are very bad at googling, but in any... 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 →
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 →
Tableau Adventurer 