Over my Christmas Holiday's I finally had a little bit of time to go back to practicing a bit / playing around with Workout Wednesday challenges and since I had't done so in a long time, there were plenty for me. Week 47 by Erica Hughes asked us to provide a solution to a three... Continue Reading →
Let’s build: Creating a Carousel in Tableau
By popular request: Are you tired of ordinary visualizations? Unveil the magic of building a captivating carousel in Tableau with just one parameter and five calculations. Skip the "why" and plunge into the how, or join me for a deep dive into the process. Harness the power of X and Y calculations, dynamic positioning, and more to create an awe-inspiring, interactive carousel.
Mastering Table Calculations Pt. 3: Practical Application at the Example of WOW2024-W15
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.
Quickie: how often do our sales staff need more days than the allowed threshold between sales?
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 →
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 →
Making the “hide” function in Tableau dynamic
What you will learn By the end of this posting you will have gained an idea of how we can make the "hide" option in Tableau dynamic which is essential when you are not only using table calculations but also applying totals from the analytics pane. The challenge Assume you want to show a 12... Continue Reading →
Summing grand totals from different sheets
For today I have a 'how-to' regarding summing up the gross totals from two different calculations on two sheets with different filters (possibly) applied. Assume your first sheet looks like this. I have randomly filtered to ship date years 2021 to 2023. and the second one like this, filtered based on order date (=2021). Also,... Continue Reading →
How to show filter selection and custom “all selection” on text marks
By incident, today's blog post is somewhat related to my last post and once again comes straight out of the Tableau forums where the solution I am going to share has been very well received. Apparently, this is a topic that concerns many users. The question asked was how we could show each single item... Continue Reading →
Tableau Adventurer 