Understanding Dynamic Sets in Tableau

Tableau

Introduction to Sets in Tableau

Sets in Tableau are custom fields that define a subset of data based on a condition. They help in filtering and segmenting data dynamically. There are two types of sets in Tableau:

Fixed Sets – The members do not change unless manually edited.
Dynamic Sets – The members update automatically based on data changes.

This guide focuses on Dynamic Sets and how to use them effectively in Tableau.

Also Read: Dimensions and Measures in Tableau

What Are Dynamic Sets?

Dynamic Sets in Tableau are collections of data points that update automatically based on user interaction or changes in data. They allow you to segment data dynamically without manually modifying set members.

Key Features of Dynamic Sets:

Automatically update when data changes.
Can be created using conditions or formulas.
Used to filter, highlight, or compare data.
Can be combined with calculated fields.

How to Create a Dynamic Set

Follow these steps to create a Dynamic Set in Tableau:

1. Open Tableau and Connect to Data

Ensure your dataset is loaded into Tableau before proceeding.

2. Create a Set

Navigate to the Data Pane (left side of the screen).
Right-click on a dimension (e.g., Customer Name or Product Category).
Select Create Set.

3. Define Set Conditions

A new window will appear with options to create the set dynamically:

General Tab: Manually select values.
Condition Tab: Define logical conditions like SUM(Sales) > 1000.
Top Tab: Rank data dynamically based on a metric (e.g., Top 10 customers by sales).
Click OK to create the dynamic set.

Using Dynamic Sets in Tableau

Once you’ve created a dynamic set, you can use it in several ways:

1. Filtering Data

Drag the set onto the Filters shelf to display only members in the set.

2. Creating a Set Action (User Interaction)

Set actions allow users to dynamically update the set based on interactions:

Go to Worksheet → Actions.
Click Add Action → Change Set Values.
Select the created set and define the action.
Users can now select data points in the visualization to update the set dynamically.

3. Highlighting Data

Place the set in the Color shelf of the Marks card.
Members inside the set will be highlighted differently from those outside it.

4. Combining Sets

You can combine multiple sets to create new insights:

Right-click on any set → Create Combined Set.
Choose two sets and define their relationship (INTERSECT, UNION, etc.).

Example Use Cases of Dynamic Sets

Here are some practical ways to apply Dynamic Sets in Tableau:

1. Top 10 Customers by Sales

Create a set based on Customer Name.
Use the Top tab and select Top 10 by SUM(Sales).
Apply the set as a filter to show only top customers dynamically.

2. Highlighting High-Value Transactions

Create a set based on Order Amount > 5000.
Drag the set to Color in the Marks card to differentiate high-value transactions.

3. Customizable Dashboard Filters

Create a set for Region.
Use a Set Action to let users click on a region and filter the dashboard dynamically.

Best Practices for Using Dynamic Sets

Use Set Actions to improve user interactivity.
Combine sets with calculated fields for advanced insights.
Optimize performance by avoiding overly complex conditions.
Always test dynamic sets with sample data before applying to large datasets.

We hope this article about Understanding Dynamic Sets in Tableau was helpful for you and you learned a lot of new things from it. If you have friends or family members who would find it helpful, please share it to them or on social media.

Join our social media for more.

Join us on Telegram

Follow our WhatsApp Channel

Also Read:

Vishal

Hi, I am Vishal Jaiswal, I have about a decade of experience of working in MNCs like Genpact, Savista, Ingenious. Currently i am working in EXL as a senior quality analyst. Using my writing skills i want to share the experience i have gained and help as many as i can.

Spread the love