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 to handle missing geo data on webedit
Lately, I had shared a quick tip of using a simply calculated field with just a country name in it to createa country field that you can use for example to beautify your map visuals. Another use case is when your dataset does not allow you to edit it and only carries values that are... Continue Reading →
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 →
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 quickie on maps
For today I have just a super tiny tip. Sometimes, your dataset only consists of data like [city name], the [latitude] and the [longitude]. No further information available. If you put that on a map, Tableau will automatically draw the dots and the map in the background like this: That is ok but not really... Continue Reading →
How to put a ratio above a side by side bar chart built from two different measures
Today we are going to deal with a request that recently popped up during our work. The question was how to put a ratio above two bars from two different measures that are grouped by year. Like this: Either, there is nothing on this topic or we are very bad at googling, but in any... Continue Reading →
Tableau Adventurer 