How to Show Overlapping Data in Tableau

Visualizing overlapping data helps you see the hidden relationships between different segments of your audience, products, or campaigns. Seeing how many customers bought both outdoor gear and camping supplies, or which marketing channels contribute to a single conversion, turns abstract numbers into actionable insights. This article will guide you through several methods in Tableau to show these valuable intersections in your data, from classic Venn diagrams to more advanced charts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Visualize Overlapping Data?

Before diving into the "how," let's quickly cover the "why." Analyzing overlapping sets is fundamental to understanding complex behaviors. It helps you answer critical business questions like:

• Marketing Analytics: Which users from our Facebook campaign also visited our website via a Google Ad? This helps you understand cross-channel influence and the customer journey.
• Product Analysis: How many customers who purchased running shoes last year also bought athletic apparel this year? This can inform product recommendations and cross-sell strategies.
• Sales Operations: Which sales leads are being targeted by multiple campaigns simultaneously? This helps in optimizing outreach and preventing lead fatigue.
• Subscription Services: What percentage of our viewer base watches both "Sci-Fi" and "Comedy" genres? This reveals content affinities and helps curate better viewing packages.

In all these scenarios, the intersection - the overlap - is often where the most valuable insights lie. Tableau provides robust tools to bring these intersections to light.

Method 1: The Dual-Axis Circle Chart (A Better Venn Diagram)

While you can technically build a classic Venn diagram in Tableau, the process often involves complex calculations for positioning circles precisely and isn't very intuitive. A dual-axis circle chart accomplishes the same goal for two sets much more easily and is faster to build.

Let’s say we want to see the overlap between customers who purchased in the "Furniture" category and those who purchased in the "Office Supplies" category.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Create Your Sets

Sets are the foundation of this method. They act as containers that group members of a dimension based on a condition you define.

1. In the Data pane, find the dimension you want to use for grouping (e.g., Customer ID).
2. Right-click on Customer ID and navigate to Create > Set.
3. Name this set "Furniture Customers."
4. Go to the Condition tab, select By formula, and enter the following:
5. Click OK.
6. Repeat the process to create another set named "Office Supply Customers," using this formula:

Step 2: Create a Calculation for the Intersection

To label the chart properly, we need a calculation that counts only the customers who are in both sets.

1. Go to Analysis > Create Calculated Field.
2. Name it Overlap Count.
3. Enter the formula:
4. Click OK.

Step 3: Build the Visualization

1. Drag your "Furniture Customers" set to the Columns shelf. Tableau will create a Count Distinct of customers by default. If not, drag Customer ID onto the Columns shelf and change the aggregation to COUNTD().
2. Drag your "Office Supply Customers" set right next to it on the Columns shelf, again ensuring it's a COUNTD(Customer ID).
3. Right-click the second pill on the Columns shelf (COUNTD(Customer ID)) and select Dual Axis.
4. Tableau might turn this into a different chart type. On the Marks card, click the dropdown for each measure (All, COUNTD(Customer ID), and COUNTD(Customer ID) (2)) and ensure the chart type is set to Circle for both.
5. On the Marks card, click on Size and increase the slider to make the circles larger and more prominent. Do this for both sets of marks.
6. Right-click on the top axis and select Synchronize Axis to ensure the circles are scaled correctly.
7. Click on Color for one of the circles and reduce the Opacity to around 60% or 70%. This transparency is what makes the overlapping area visually distinct.
8. Finally, drag the field COUNTD(Customer ID) to the Label mark for each circle. Additionally, drag your "Overlap Count" calculated field onto the canvas where the circles overlap, you may need to adjust its position manually using text annotations for clarity.

Now you have a clean, clear visualization of two overlapping sets and the exact number of entities they share.

Method 2: Using Sets for Direct Comparison

Sometimes, you don't need a specific chart type, you just want to compare the behavior of overlapping groups against non-overlapping ones. Sets are perfect for this more direct analysis.

Step 1: Create a Combined Set

Assuming you already created the "Furniture Customers" and "Office Supply Customers" sets from the previous method:

1. In the Data pane, hold down Ctrl (or Cmd on Mac) and select both sets.
2. Right-click one of them and choose Create > Combined Set.
3. Name this new set "Combined Customer Groups".
4. For the combination logic, make sure the icon for Shared Members in Both Sets is selected. This creates a set containing only the customers in the overlap.
5. Click OK.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Use the Set as a Dimension

This "Combined Customer Groups" set now acts like a dimension that splits your data into two parts: "In" (customers who bought both) and "Out" (everyone else).

1. Drag this new combined set to the Rows shelf.
2. Drag a measure you want to analyze, like Sales, to the Columns shelf.

Instantly, you get a bar chart comparing the total sales from the overlapping segment versus all other customers. You can replace Sales with Profit, Order Quantity, or any other metric to see how the behavior of this specific group differs.

**Pro Tip:** To get a three-way comparison (Furniture Only, Office Supplies Only, Both), create a calculated field like this:

IF [Furniture Customers] AND [Office Supply Customers] THEN "Both"
ELSEIF [Furniture Customers] THEN "Furniture Only"
ELSEIF [Office Supply Customers] THEN "Office Supplies Only"
ELSE "Neither"
END

Using this new dimension in your views provides a complete breakdown of sales, behavior, or any other metric across all segments.

Method 3: Upside-Down Bar Charts (UpSet Plots) for Multiple Sets

As soon as you need to visualize the overlaps between three or more sets, Venn diagrams become nearly impossible to read. An UpSet plot is a far superior alternative. While a true UpSet plot in Tableau requires some advanced techniques, you can build a simplified version to analyze multiple intersections clearly.

This method displays the size of each intersection as a bar and uses a dot matrix below it to indicate which sets are part of that intersection.

Step 1: Create Calculated Fields for Segments

Imagine you have three sets: "Set A," "Set B," and "Set C." You'll need to create a calculated field that categorizes each customer into their specific combination.

1. Go to Analysis > Create Calculated Field.
2. Name it Segment Definition.
3. Enter a formula structure like this:

**Important:** The order of an IF/ELSEIF statement matters. You must list the most complex intersections (all three sets) first, followed by two-set intersections, and finally the single sets.

1. Click OK.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Build the Bar Chart

1. Drag the "Segment Definition" dimension to the Columns shelf.
2. Drag Customer ID to the Rows shelf and change its aggregation to COUNTD().
3. Sort the bars descending to see the largest intersections first. You now have a clear bar chart showing the size of every possible combination, which is much more readable than a messy three-circle Venn diagram.

To add the dot matrix component visually, you can create a second worksheet that maps dots to the segments and combine them in a dashboard for a complete UpSet Plot experience.

Final Thoughts

Visualizing overlapping data transforms how you see your business, allowing you to move from basic counts to understanding customer segments and cross-channel behaviors. Whether using a simple dual-axis chart for a quick look at two groups or employing calculated fields for an in-depth analysis of multiple intersections, Tableau offers the flexibility to discover these crucial insights.

While mastering these techniques in Tableau is a valuable skill, setting up sets and complex calculated fields for every new question can take time. At our company, when we need to rapidly identify these valuable segments without stopping to build new visuals, we use tools like Graphed. We can connect our data sources, like Shopify or Google Analytics, and simply ask natural language questions such as, "show me the number of users from our summer sale campaign who also made a second purchase within 30 days," and instantly get the answers we need. This enables us to quickly find those high-value overlaps and then dive deeper into Tableau for more comprehensive analysis.