Tableau: Join Tables and Build a View

In this Exercise, we will Join Tables and Build a View

You want to build a view that shows a company’s orders that were returned. The data source has separate tables for orders and returns. You will join them and then build a view that shows the count of records that are present in both tables, by category.

You will create a view that shows the Count of Orders that were returned, broken down by Category.

Open the file: join_tables_and_build_a_view_starter_10.0.twbx

Create an Inner Join between the Orders and Returns tables

Drag Orders from the Sheets pane to the canvas.

On Orders, click the menu arrow and select Open (Or you may double-click Orders to Open it)

Drag Returns from the Sheets pane to the canvas. A Join relationship dialog opens

Create a view that shows the Count of Orders that were returned, broken down by Category. Name the view Orders Returned.