What is a Dynamic Set in Tableau?

Dynamic sets in Tableau are a powerful feature that automatically updates your data segments based on conditions you define. Instead of manually grouping members, you create a rule, and Tableau does the rest, ensuring your analysis is always up-to-date. This article will walk you through what dynamic sets are, how to create them step-by-step, and practical ways to use them to find valuable insights.

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

So, What Exactly is a Set in Tableau?

Before diving into dynamic sets, let's quickly cover what a set is in the first place. Think of a set as a custom group or a segment of your data that you create based on existing dimensions. In essence, you're dividing your data into two groups: members that are in the set and members that are out of the set.

For example, you could create a set of your top-performing sales regions, a set of customers from California, or a set containing specific product categories. This "in/out" binary is incredibly useful for comparing segments, filtering views, and creating more advanced calculations.

There are two main types of sets in Tableau:

• Static Sets: These are fixed lists. You manually select the members that belong in the set, and that list never changes unless you edit it yourself. A static set is like a printed guest list for an event - it's defined once and stays the same.
• Dynamic Sets: This is where the magic happens. A dynamic set's members are determined by a rule or condition. If your underlying data changes, the members of the set update automatically to reflect those changes. It's like a VIP list where members are added or removed based on their latest spending habits.

The Power of Dynamic Sets

The main advantage of using dynamic sets is automation. Manually updating lists of your "top 10 customers" or "underperforming products" every week is tedious and prone to error. Dynamic sets eliminate this chore, saving you time and ensuring your dashboards always show the most current information.

Because they are condition-based, they make your analysis much more robust. New data flows in, customers change their buying patterns, and product performance fluctuates. Dynamic sets adapt to these changes in real-time so you can focus on interpreting the insights, not on constantly rebuilding your reports.

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

How to Create a Dynamic Set in Tableau (Step-by-Step Guide)

Let’s build a dynamic set from scratch. For this example, we’ll use a common business scenario: identifying your top 10 customers by total sales from the Sample - Superstore dataset included with Tableau.

Step 1: Choose Your Dimension

First, find the dimension you want to base your set on. In our case, we want to group customers, so we'll use the Customer Name dimension. In the Data pane on the left, find Customer Name, right-click on it, hover over Create, and then select Set...

Step 2: Configure the Set

The "Create Set" dialog box will open. Here is where you define the rules for your dynamic set.

1. Name your set: Give it a descriptive name. Let's call it Top 10 Customers by Sales.
2. Go to the 'Top' tab: This dialog has three tabs: General, Condition, and Top. The "General" tab is for creating static sets by manually picking members. Since we want a dynamic rule, we'll go to the Top tab.
3. Define the rule:

This configuration tells Tableau: "Look at all customer names, calculate the sum of sales for each one, and then put the 10 customers with the highest sum of sales into this set." When you click OK, the new set will appear in the Data pane at the bottom, under the Sets section.

Step 3: Use the Set in Your View

Now that you've created the set, you can use it in a visualization. Drag Sales to the Columns shelf and your newly created set, Top 10 Customers by Sales, to the Rows shelf.

You’ll immediately see a bar chart with two bars: "In" and "Out." The "In" bar represents the total sales from your top 10 customers, while the "Out" bar shows the total sales from everyone else. This is a powerful, instant comparison.

To see the individual names, you can also place the Customer Name dimension on the Rows shelf and place your set on the Color tile in the Marks card. Tableau will automatically color the top 10 customers differently from the others, making them easy to spot.

💡 Pro Tip:

The default "In" and "Out" labels aren't very descriptive. You can change them! Right-click the set on the Rows shelf or the Color legend and choose Edit Aliases. You can change "In" to "Top 10 Customers" and "Out" to "Other Customers" to make your chart more readable for your audience.

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

Practical Use Cases for Dynamic Sets

Once you get the hang of creating them, you'll find endless ways to use dynamic sets. Here are a few practical examples relevant to marketing, sales, and e-commerce.

1. Identifying High-Value Customers

Instead of just finding the top 10, maybe you want to define a "high-value customer" as anyone who has spent more than $5,000. For this, you’d use the Condition tab in the "Create Set" dialog box.

• Create a set based on Customer Name.
• In the Condition tab, select By formula: and enter the condition:

SUM([Sales]) > 5000

Now, any customer whose lifetime sales exceed $5,000 will automatically be added to this set.

2. Monitoring Underperforming Products

Dynamic sets aren't just for highlighting the positive, they're excellent for flagging issues. You can create a set to track products with negative profit margins automatically.

• Create a set based on Product Name.
• Use the Condition tab with the formula:

SUM([Profit]) < 0

You can drop this set on your colors mark to instantly highlight unprofitable products in any view, giving you an early warning system to investigate issues.

3. Tracking Recently Active Users

Engagement metrics are crucial. Let's create a set of customers who have made a purchase in the last 60 days. This is perfect for analyzing an active user cohort or building a targeted list for a new marketing campaign.

• Create a set based on Customer Name.
• Use the Condition tab with the formula:

MAX([Order Date]) >= TODAY() - 60

This formula finds the most recent order date for each customer and checks if it falls within the last 60 days. The set membership will update every single day.

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

Combining Sets for Deeper Insights

Things get even more interesting when you start combining sets. Say you have two sets:

1. High-Value Customers: Customers with more than $5,000 in sales.
2. Recently Active Customers: Customers with a purchase in the last 60 days.

You can combine these sets to create highly specific segments. In the Data pane, select both sets (by holding Ctrl or Command), right-click, and choose Create Combined Set... You'll see several options, represented by Venn diagrams:

• Intersection (Shared members): This creates a set of customers who are both high-value and recently active. These are your best, most engaged customers.
• Union (All members): This creates a set of customers who are either high-value or recently active.
• Subtraction (Except shared members): Creating "High-Value Customers EXCEPT Shared Members" gives you a list of high-value customers who have not purchased recently. This is a perfect segment for a win-back or re-engagement campaign!

Dynamic Sets vs. Filters: What's the Difference?

A common question is, "Why not just use a filter?" While filters are great for temporarily hiding data in a specific worksheet, sets offer more power and flexibility.

• Scope: Filters apply only to the worksheet they're configured on. Sets, on the other hand, are saved in your Data pane and can be reused across any number of worksheets in your workbook.
• Functionality: A filter's main job is to include or exclude data from a view. A set creates a new, reusable field that segments your data into "in" and "out" groups. This allows you to use them as a dimension for coloring, grouping, and in calculations, opening up more advanced analytical possibilities than a simple filter.

Think of it like this: a filter is like using a magnifying glass to look at a specific part of a photo. A set is like taking a highlighter and marking a group of people in that photo so you can easily reference that same group whenever and wherever you look at it.

Final Thoughts

Tableau's dynamic sets are a fantastic tool for creating automated, rules-based segments in your data. By moving past static lists and embracing conditions, you can save a ton of time on manual reporting, keep your dashboards current, and uncover deeper insights by comparing distinct groups. They empower you to build more intelligent and responsive analyses that adapt as your business evolves.

While mastering dynamic sets in Tableau helps you build powerful reports, sometimes you just need a quick answer without getting into configuration dialogs. With Graphed, we’ve focused on simplifying this process. You can just ask a question like, "Compare my sales from customers who bought in the last 30 days versus everyone else" and instantly get the chart you need. We use natural language to connect to all your marketing and sales data, so you can stop manually building reports and just ask questions to get the insights you’re looking for.