How to Add Two Sheets in Tableau

Combining multiple views is a common and powerful task in Tableau. Whether you need to place two charts side-by-side for comparison or merge the underlying data from different sources into a single visualization, Tableau provides several ways to get the job done. This guide will walk you through the most common methods for adding sheets together, from the simple dashboard drag-and-drop to more advanced techniques like data relationships and parameter actions.

The Easiest Method: Placing Two Sheets on a Dashboard

The most straightforward way to "add two sheets" is to place them on a dashboard. This approach is perfect when you have two distinct, fully-built visualizations and you want to display them simultaneously. A dashboard acts as a canvas where you can arrange worksheets, text, images, and interactive elements like filters.

Imagine you have a map showing sales by state and a bar chart showing sales by product category. Placing them on the same dashboard gives you a comprehensive view of both geographic and product performance in a single glance.

Step-by-Step Guide to Using a Dashboard

1. Create Your Worksheets: First, build the individual visualizations you want to combine. Let's stick with our example:
2. Create a New Dashboard: In the bottom tab rail, click the "New Dashboard" icon (it looks like a grid of four squares).
3. Drag and Drop Your Sheets: On the left side of the dashboard view, you'll see a list of all your created sheets. Simply click and drag "Sales by State" onto the empty canvas. By default, it will take up the entire space.
4. Add the Second Sheet: Now, drag "Sales by Category" onto the canvas. As you drag it, Tableau will show you gray shaded areas indicating where you can place the sheet — to the right, left, top, or bottom of the first sheet. Release the mouse button when you're happy with the position.
5. Arrange and Resize: You can now adjust the size of each visualization by dragging the border between them. You can also move any legends or filters that appeared to a more convenient location.

Pro Tip: Make Your Filters Interactive

To make your dashboard even more powerful, you can make a filter from one sheet apply to the other. For example, you can add a "Region" filter from your map view.

• On the dashboard, find the filter card for "Region".
• Click the small downward arrow on the top-right of the filter card.
• Go to Apply to Worksheets > Selected Worksheets...
• In the pop-up window, check the box for both "Sales by State" and "Sales by Category".

Now, when a user selects a region like "West," both the map and the bar chart will update to show data only for that region, creating a fully interactive analysis experience.

When Data is Separate: Merging Sheets with Relationships or Joins

Sometimes, your goal isn't just to see two charts at once, but to create a single chart using data that lives in two different tables or sheets. For instance, you might have customer order information in one sheet and customer demographic information in another. To build a chart like "Sales by Age Group," you'll need to combine this data first.

This is done in the "Data Source" tab in Tableau using either Relationships or Joins.

Understanding Relationships (The "Noodle Method")

Relationships are Tableau's new, flexible, and recommended way to combine data from multiple tables. When you drag two tables onto the data source canvas, Tableau connects them with a flexible line (colloquially called a "noodle").

Think of it as setting a rulebook for how the tables relate. The tables remain separate and Tableau intelligently brings in data from each table as needed for a specific visualization, automatically handling aggregation and preventing data duplication that can sometimes happen with traditional joins.

How to Create a Relationship:

1. Navigate to the Data Source tab at the bottom left of your workbook.
2. Drag your first sheet or table (e.g., Orders) onto the canvas.
3. Drag your second sheet (e.g., Customer Info) onto the canvas and drop it near the first one.
4. Tableau will create a "noodle" between them and automatically try to identify the common field (like Customer ID).
5. If you need to change the fields, click on the noodle itself to open the "Edit Relationship" dialog and specify the columns that link the two tables.

Once the relationship is established, you can go to a new worksheet and you'll see fields from both tables in the data pane, ready to be used together in a single chart.

Using Traditional Joins

Joins physically merge tables into a single, typically wider, table before any analysis begins. While Relationships are often better, joins are still useful in certain scenarios. There are four main types:

• Inner Join: Only includes rows where the join key exists in both tables. (e.g., Only customers who have placed an order).
• Left Join: Includes all rows from the left table and matching rows from the right table. (e.g., All customers, and the order data for those who have placed an order).
• Right Join: The opposite of a left join. Includes all rows from the right table.
• Full Outer Join: Includes all rows from both tables, regardless of whether there's a match in the other table.

You create joins in the Data Source pane by opening the table you dragged onto the sheet and selecting the join type from there. Relationships are generally the better starting point, but it's good to understand joins for more complex data prep.

For Vertically Stacked Data: Combining Sheets with a Union

What if you don't want to add columns, but rows? If you have multiple sheets with the exact same column structure — for example, monthly sales reports — you can combine them into one master table using a Union. This stacks the data vertically.

For example, if you have January Sales.csv, February Sales.csv, and March Sales.csv, a union lets you create a single view for analyzing the entire first quarter.

How to Create a Union:

1. Go to the Data Source tab.
2. Drag your first sheet (e.g., January Sales) onto the canvas.
3. Drag your second sheet (e.g., February Sales) and drop it directly below the first sheet, where you see an orange drag area labeled "Drag table to union".
4. Continue this for any additional sheets. Tableau will append the rows and add handy columns like Table Name and Sheet that you can use to identify the original source of each row.

Advanced Technique: Swapping Sheets for an Interactive Dashboard

A "sheet swap" is a clever technique that allows an end-user to choose which visualization to display within a single container on a dashboard. This is perfect for saving space and providing a customized user experience. It uses a Parameter control (like a dropdown list) to switch between different worksheets.

Step-by-Step Guide to Sheet Swapping:

1. Create Your Sheets: Build the two distinct worksheets you want to let users swap between. For instance, let's use a "Sales Over Time" line chart and a "Profit by Region" map.
2. Create a Parameter:
3. Create a Filter Calculation: Create a calculated field that will act as the switch.
4. Apply the Filter to Each Sheet:
5. Assemble the Dashboard:

Now, when you select "Sales" from the parameter dropdown, only the sales chart will appear. When you select "Profit," it will be replaced by the profit map. This is a fantastic way to display two sheets in the same dedicated spot.

Final Thoughts

As you can see, "adding two sheets" in Tableau can mean anything from simple side-by-side placement on a dashboard to complex data merging with relationships or dynamic swapping with parameters. Understanding each of these methods allows you to choose the right technique for your specific analytical goal, helping you build more insightful and user-friendly reports.

Mastering tools like Tableau takes time, especially when you have to dive into data-source configurations, fine-tune joins, and build complex dashboards manually. At Graphed, we created a way to skip all that manual work. You can connect your data sources in a few clicks, and then just ask for the visualization you need in plain English. We handle the data connections and instantly build a live, updating dashboard for you, turning hours of tedious report-building into a thirty-second task.