Join Calculations in Tableau

Опубликовано: 11 Август 2022
на канале: OneNumber - Tableau Experts
4,526
49

Connect with us!
• Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
• Connect with Oliver Linley on LinkedIn:   / oliverlinley  

• Access the Miro Board here: https://miro.com/app/board/uXjVOjuDYY...

When Would You Use a Join Calculation?

Tableau is pretty good at joining tables together. As long as you have a common field in both tables you want to join, Tableau can do the rest.

But what if you don’t have a common field? Or, what if your common field is in a slightly different format in one of the two tables?

A join calculation can solve a lot of your problems!

What is a Join Calculation?

A join calculation is a special kind of calculated field that can help Tableau link rows between two tables that we want to join. By using a join calculation, we can show Tableau how to make both fields exactly the same by editing one so it’s the same as the other.

How to Join on a Calculated Field

In this week’s tutorial, we’ll look at two examples to see how to join on a calculated field when your tables don’t exactly align.

Chapters:

0:00 Intro
0:43 How does a join work?
3:20 When do you need a join calc?
4:20 How does a join calc work?
8:18 What if your fields don't match?