In the final part of the series on table calculations, we apply our knowledge to create a dynamic trellis chart for the WOW2024-W15 challenge. Addressing the challenges of data padding and domain completion, we ensure the accuracy of our visual results. Two options - "At the Level" and Domain Completion - are explored to fix display inconsistencies, concluding our practical application of table calculations.
Mastering Table Calculations Pt. 2: Excursus on Domain Padding and Domain Completion
This part of the series on table calculations explores Domain Completion and Domain Padding as methods for dealing with sparse data in Tableau.
Mastering Table Calculations Pt. 1: From Basics to Advanced Settings
Ignited by WOW2024-W15 my new mini-series focuses on table calculations in Tableau. Part 1 delves into the intricacies of table calculations going from bascis to advanced. Data densification is and its relation to table calcs is explored in Part 2. The seriess concludes with a practical application of the learnings at the example of WOW2024-Week 15 challenge in Part 3. Various aspects of table calculations, including addressing, partitioning and especially the infamous at the level settings as well as nested calculations, are examined in detail, providing a comprehensive understanding of advanced settings and applications.
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 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 →
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 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 →
Tableau Adventurer 