In my previous blog post, I started with some basics of table calculations in Tableau. This post and the next are going to build on that foundation by walking through the various kinds of table calcs there are and finally discussing more advanced options for...
Table calculations are a special group of calculations in Tableau that apply to the values that are currently in your view or viz, and they do not consider measures or dimensions filtered out of the view. These calculations are only applied after almost everything else...
How the heck does this function work? You know what? I have been working with (and teaching) Tableau for over five years. Have a guess at when I finally understood the PREVIOUS_VALUE function ...
As the world remains in quasi-quarantine, we’ve been staying connected and learning in our home offices thanks to InterWorks’ virtual Lunch & Learn series hosted by our APAC team. This month’s event covered five essential tips on table calculations. Table calculations are a special feature inside...
One of the most frequent tasks you might come across when working with Tableau is comparing data over time. Any KPI that is measured needs to be put into some kind of context to make it more tangible and give a feeling of perspective. “Our...
Question: I’m using a table calculation comparing the same month last year, and my view shows blanks due to the date range I have applied. Is there a way to fill in the blanks correctly? I’ve duplicated the user’s view somewhat using Superstore data. You can...
Let me start off here by laying out the pros and cons of using table calculations when it comes to measuring distance. Pros: Table calcs do all of the work instead of us having to type out every latitude and longitude coordinate in a calculated...
Calculated fields are awesome. They can be used to discover incredible insights in your data by using fields from your original data source. And if some of those fields are latitude and longitude, they can be used for more than just plotting. You truly can...
Question: I’ve been making updates to our Tableau visualizations, and I can’t seem to figure out how to create a mark on the latest date. I also would like to know whether that mark is more or less than the previous date. Is this possible?...
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...
In the last post of our series on custom sorts in table calculations, we’ll examine one of the most common questions that I get from Tableau Training. In fact, I just had this question last week in Perth, Western Australia by a student named Mayank. Here’s...
In part one of this two-parter, I went into a lot of depth on how to use custom sorts within table calculations. I highly recommend reading that article first before continuing with the second part. In this post, we’re going to apply those ideas to illustrate...
In a Desktop II: Intermediate course I recently taught, a student asked, “When would I ever need the specific dimensions option with table calculations?” This is a great question! We know that we can utilize the prebuilt options in our table calculation dialog box to...
(Note: All the charts we build are included at the bottom of this article in a packaged workbook available for you to download.) Table calculations in Tableau can get complicated very quickly. But these extra little features make a big difference, such as computing specific dimensions,...
Table calculations are one of the hardest functions to understand in Tableau Desktop. A lot of us are guilty of clicking through every single option on the table calculation window until we find something that looks right. There is a lot of great material out...
While working with a recent client, we tried to answer which product categories their business should keep investing in and which categories are not worth the effort of selling. At this point, I remembered the strategic marketing classes I took during my time at university....
Quick table calculations in Tableau are a great way to understand and visualise relationships between measure values. The most frequently used calculation types (running total, difference and percent difference) are core metrics in most financial management reports. What Are Ad Hoc Calculations? Quick table calculations were created to...
Here’s a question that came out of a class from one of our other trainers: “Student wants a running sum to restart every time the value drops to zero.” How very interesting – a table calculation with a conditional scope. Let’s tackle this problem. Scope & Direction First, let’s...
At the start of this Deep Dive series, I stated that there were four standard use cases for parameters: filters, bins, reference lines and calculated fields. What about other areas, such as table calculations? Why can’t we use parameters there? The answer is: You can! You just...
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...
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