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.
Two quick ideas on reference lines
Here are two quick questions that were raised recently, both regarding the use of reference lines. Question: How to create a custom reference line? In this case, the user wanted to show a median as a reference line but only for values that exceeded a certain threshold. So, in effect he had a bar chart... Continue Reading →
