From the course: Tableau 10 for Data Scientists

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create custom joins through calculations

Create custom joins through calculations - Tableau Tutorial

From the course: Tableau 10 for Data Scientists

Start my 1-month free trial

Create custom joins through calculations

“

- [Narrator] Tableau 10 introduced the idea of making joins across two different data sources, and then viewing them as a single data source. In 10.2 they've introduced joins across calculations. To understand what that means, let's look at an example. I have two data sources, one called customer orders, one called customer segments. Customer orders has the forename and the surname, an order ID, and some measure of sales. This is what the data looks like when we try to visualize it. Now our second source, customer segment, has all the customer names and the customer segment that each customer is part of. Now something I might want to know is, what's the total amount of sales for each of the customer segments? To do this, I want to join these two data sources together. However, there is no common field between the two. One has customer name, whereas customer orders has got the forename and the surname. Now in order to join those two together, I need to do a calculation to merge the…

Contents