Cross Join Database Filter and Continuous Bar Chart in Tableau 10.0

Step 1: – Open a new workbook on Tableau 10.0 and add “World Indicators “as the data source. Now click on “Add” present on the right of connections and add “Personal Vehicle Sales Global” as second data source to the worksheet.

Now drag the sheets present under both the data source connections to the screen and Tableau 10.0 automatically compiles the inner join between both the data sources. If it doesn’t find any connection, we can manually set the join between both the data sources by clicking on union symbol.

 

1

 

Step 2: – Now move to the sheet1 and create a bar chart with Year field on the column and Sum of Total Population on the row field.

 

2

 

Step 3: – Now insert a Region filter to the sheet. Right click on the region filter and move to the ‘Apply to Worksheets’ option and select ‘All Using Related Data Sources’ Option.

This technique makes the filter as “Global Cross Database Filter”. How this works is further explained in the example later on this blog in step 5.

 

3

 

Step 4: – Now right click on the Year field present on the column and select Continuous.

 

4

 

On the earlier versions of the Tableau there was no option to use Year like dimensions as continuous. And now this makes the graph more logical than before.

Further we can change the Size and Alignment of the bars from the Size option in the Marks section to get the desired graph like overlapping bar chart.

 

5

 

Step 5: – Now create another sheet with Year and Sum of Total Sales.

 

6

 

Here you can find that the Region filter is already present in the sheet by default.

Now Dis-select all the regions and select only Asia from the filter and we can see the graph changing according to the filter.

 

7

 

Now we move back to the previous sheet i.e. Sheet1 and we find that the Bar chart has been changed according to the filter applied in the previous sheet.

 

8

 

Leave A Reply

Your email address will not be published. Required fields are marked *