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 →
Automatically select the last day of a period in a natural date-hierarchy drill down
Somewhat akin to what I wrote about lately, today we will be focussing on a question that was raised in the forums today. The asking person wanted to use the natural date hierarchy drill down (i.e. using the little plus / minus icons on date fields) to drill from year to quarter, month etc. This:... Continue Reading →
How to create a multi-language help-overlay
Dashboards often come with supportive overlays that help users to better understand the charts, data or even insights they are looking at in order to make the most of the data provided (and eventually: to make the most of your work as the designer of the dashboard). Let us leverage the utility of these overlays... Continue Reading →
Tableau Adventurer 