If anyone ever told you it’s not possible to make a dynamic fiscal calendar in Tableau, then you weren’t talking to someone from InterWorks. It may require a few steps, but as is often the case, all we need are a few clever calculations. So, what...
It’s 9 a.m., and you’ve just entered the classroom for your Tableau class, whether it’s Fundamentals or Advanced. Or, maybe you’ve just logged into the virtual classroom and are waiting for the rest of the students to show up in the chat window. How much...
While not a regular occurrence, I have come across situations where a client wants to display a hidden sheet with an action filter but wants to enable different worksheets to activate the hidden sheet. If the sheets are filtering on different fields when you set an...
We get lots of questions conducting Tableau trainings across the country. Many of them unveil new functionality that Tableau releases that we as trainers come across first when teaching new Tableau users. The below question has many answers, but I wanted to highlight something from Tableau...
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...
Date Fields are one of the trickiest concepts for Tableau beginners. In this Tableau Training Tips video, I explain what they are as well as how/when to use continuous and discrete fields. Feel free to follow along in Tableau on your desktop to master this concept in...
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...
One of the common problems that clients are seeking to solve is a way to easily compare values from two different periods against each other. They want the ability to compare the same period between two years, a period against an immediately preceding period and...
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...
In our last guideline, we’ll revisit another tip on how your dashboard’s layout can impact performance: "Fix dashboard size relative to end-user consumption. Automatic sizing is less efficient than specifying dashboard size." It’s not all about size … though I’ve heard it’s mightily important. Automatic Sizing There is a...
A common question that comes up trainings is: ”What does the small grey bar within the quick filter box represent?” Using quick filters is one of the easiest ways to provide end users with the ability to control what they want to see. Although they are quick, they...
We are onto our last category of the Tableau Performance Checklist, Dashboard Layout. For our next guideline: "Limit the number of worksheets on a dashboard. If you have more than four visualizations on a dashboard, strongly reconsider." Let’s begin! Dashboarding or Dash-boring The allure of putting as much information on...
Averages are great. They take up very little space to report, everybody wants them and we all understand exactly what an average is … or do we? An average as we typically think of it is what we call the mean in statistics. To find...
A common question that comes up in trainings is: “How do ZIP codes work in Tableau? Do I need to add in leading zeros, or can I leave them out?” As geographic fields become increasingly available in the field of analytics, aggregating customer information to ZIP code level...
It’s been a while since I wrote in this series, but I was recently conducting a training and was asked a question that I have never been asked. I’m sure it comes up regularly, but I never came across it. I was asked: “Tableau makes the week...
Here’s the second item under Local Computations: "Table calculations are powerful, but they can be slow. They are dependent on the local computation engine and can require substantial memory." Let’s get started. Table Calculations Table calculations are computations that use the values in the entire table and can restructure...
Here’s the first guideline from the Local Computations category: "Even if a workbook is published to Tableau Server, local computations still impact performance. Leverage the power of Tableau Server whenever possible by limiting local computations such as groups, hierarchies, reference lines, table calculations and blending." Let’s get...
With built-in Tableau integration, using maps couldn't be easier! Occasionally, however, we want to get creative and display more information within the map. Recently, I was asked, "When I have a parameter to choose which measure I want to view, how can I display a different color...
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