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 →
Tableau Adventurer 