×
Channel

# Table Calculations Tag

## Tableau Table Calculation Highlights: Types of Calcs

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...

## Tableau Table Calculation Highlights: The Basics

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...

## Understanding PREVIOUS_VALUE in Tableau

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 ...

## Virtual Event Recap: Five Essential Tips for Table Calculations

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...

## The Ultimate Guide to Year-over-Year Comparisons in Tableau

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...

## Advance with Assist: Filling in Null Records Without Filtering

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...

## Going the Distance in Tableau: Becoming Fully Dynamic with Table Calculations

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...

## Going the Distance in Tableau: Fixed Point Comparisons

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...

## Advance with Assist: Marking the Latest Date on Trend Line

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?...

## Hiding Data in Tableau with Table Calculations and Level of Detail Calculations

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...

## Tableau Deep Dive: Table Calculations – Custom Sorts, Part Three

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...

## Tableau Deep Dive: Table Calculations – Custom Sorts, Part Two

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...

## Questions from Tableau Training: How to Use Specific Dimensions in Table Calculations

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...

## Tableau Deep Dive: Table Calculations – Custom Sorts, Part One

(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,...

## Fun with Window Functions in Tableau

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...

## How to Create a BCG Growth-Share Matrix in Tableau

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....

## How to Create Quick Table Calculations in Tableau

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...

## Questions from Tableau Training: Conditional Scope on Tableau Calculations

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...

## Tableau Deep Dive: Parameters – Table Calculations

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...

## Tableau Deep Dive: LOD – LOD Calculations vs. Table Calculations

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 uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

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

×