While visualizations provide a valuable snapshot of data, they often fall short in accommodating the diverse analytical needs of decision-makers. For example, imagine a visualisation shows total sales by year. This is useful. But what if we want to compare this with the average spend...
I had some fun with ChatGPT asking it questions about cohort analysis this week. I’ll spare you the 4,000 words it created on general questions I prompted on cohort analysis and focus on the topics related to Tableau, Level of Detail expressions and cohort analysis...
The initial request that led me to create this dashboard came from a client working in the sales department of a manufacturing company. The challenge was unique: if a customer requested a product that was out of stock, they could quickly find alternative products with...
Question: My calculation for percentage isn’t returning the right values, but the data is there. I’m getting the sum of a single product, not the full sum. What do I need to do? Understanding what Tableau does with calculations and aggregations is important when building calculated...
Have you ever wanted to hide some of your data but not filter it? In this article, I will demonstrate how to hide certain pieces of data without filtering them out of the calculation results. I’ll be using a method that involves level of detail...
While attending the Tableau Conference in London, we received many interesting questions. I want to share one of them here. We want to see sales performance over time. What if we sometimes want to compare different sub-categories separately and just want to see the development...
The idea behind this blog post is to document a novel approach I have come up with to allow for date selection in a report that defaults to the most recent time frame. There are multiple ways this sort of problem can be solved. My...
During a recent project, I received an interesting question: “Can we swap what dimension is displayed in a stacked bar chart based on a filter being applied?” I’ve decided it would be easier for me to answer this question by showing you how to do it with the...
This week, I gave a talk on level of detail expressions at the Atlanta Tableau User Group. Preparing for that talk, I watched lots of video. The speech by Ian Coe and Adam Kamor, Pick Your Poison, LOD Expression or Table Calc, inspired this dashboard....
At first glance, it could appear as if there is redundancy between level of detail calculations and table calculations. In fact, you might wonder if you could use table calculations to accomplish much of the functionality for LODs. Let’s consider a simple use case for...
In Part 4 of our Tableau Deep Dive on level of detail, we’re going to examine the last of the three LOD calculation types – Fixed. Remember: This series is building upon each article, and I highly recommend that you start with Part 1 and go...
Fixed LOD Berechnung Die INCLUDE- wie auch die EXCLUDE-Berechnungen verhalten sich relativ zur Visualisierung, in der sie genutzt werden. Wenn Du mit INCLUDE eine Dimension einschließt, die bereits in der Ansicht vorhanden ist, wird die Berechnung keinen extra Effekt haben. Genauso wird EXCLUDE keinen Effekt haben, wenn...
This is the third article in our Tableau Deep Dive on level of detail. Part 1 reviewed the idea of detail. Part 2 introduced level of detail calculations and examined the Include LOD calculation. Let’s now jump into Exclude. A Use Case For our examples in this article, we’ll...
In the previous article of this Deep Dive on LODs, we talked about Detail in general for Tableau Desktop. In Part 2, we’ll explore the Include level of detail calculation. Start With the Data Before I go into Tableau Desktop, I always think it’s foundationally important to...
Level of detail (LOD) is a feature that was introduced in Tableau Desktop v9. While it offers a great amount of flexibility and control over how you use the data in your visualization, it can be a bit tricky to fully understand. We teach level of...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072