From the course: Complete Guide to Tableau for Data Scientists

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Using calculations in a join

Using calculations in a join - Tableau Tutorial

From the course: Complete Guide to Tableau for Data Scientists

Start my 1-month free trial Buy for my team

Using calculations in a join

“

- [Instructor] The most common use case for calculations is when we want to create a calculated field, which will create a new column in our data. But there's another really useful thing we can do in calculations and that's when we're trying to join two tables together, where we need to manipulate the data in one of the columns to match the data in the other column as part of the join or the relationship. To look at that, let's take a look at this data. So I'm looking at the sum of sales broken down by each of the four regions in our data. Now I have a second data source that actually lists all of the number of stores for each of the regions. Now I need to import that data in because I want to see how does the sales per store stack up. In order do that, we need to add in our second data set. So I'm going to go to the top of my data pane. Going to right click on the data source name, click edit data source. I'm going to add a connection to my file. Now this is a text file, it's a CSV…

Contents