7.2 Sets, Set Actions & Combined Sets vs. Groups

7.2 Sets, Set Actions & Combined Sets vs. Groups

In data analytics, segmenting customers, products, or transactions into distinct cohorts is essential for comparative analysis. Tableau provides two primary native structures for clustering discrete dimension members: Sets and Groups. While novice users often conflate the two, their architectural mechanisms, operational flexibility, and calculation capabilities differ fundamentally.

For the Salesforce Certified Tableau Data Analyst, mastering Sets—including dynamic condition rules, Combined Sets, and interactive Set Actions—is a critical competency. This section explores how Sets function, how they operate within the Order of Operations, how to configure advanced dashboard interactions, and how they decisively surpass Groups in enterprise visual analytics.

---

Set Mechanics: The IN/OUT Paradigm

A Set is a custom field in Tableau that defines a subset of data based on explicit criteria. Every set evaluates dimension records into a binary condition: members that meet the criteria belong to the IN set, and members that do not belong to the OUT set.

[All Dimension Members]
   |--> IN  (Satisfies Set Condition: Highlighted / Filtered / Aggregated)
   |--> OUT (Fails Set Condition: Subdued / Excluded / Baseline Comparison)

When a Set is dragged onto a visual shelf (such as Color, Rows, or Columns), Tableau displays it as a discrete boolean dimension showing IN and OUT. Sets can also be shown as standard filter controls, where users can choose to display 'Show In/Out of Set' or expose individual set members as a multi-select list.

Static (Fixed) Sets vs. Dynamic Sets

Tableau supports two fundamentally different set architectures:

1. Static (Fixed) Sets

• Creation Method: Created directly on the visual canvas by selecting individual marks (or rows), hovering over the tooltip, clicking the Set icon (two overlapping circles), and choosing Create Set.
• Behavior: The set captures the exact list of primary keys or dimension values selected at that exact moment in time.
• Limitation: Static sets never change. If new transactions enter the underlying database or existing records change their sales volume, the membership of a static set remains hardcoded. They are appropriate only for one-off ad-hoc investigations (e.g., investigating a specific batch of 12 defective shipments).

2. Dynamic Sets

• Creation Method: Created from the Data pane by right-clicking a dimension and selecting Create > Set.
• Behavior: Dynamic sets evaluate rules dynamically against the data engine. As the data updates, dimension members automatically move IN or OUT of the set.

Dynamic Set Configuration Tabs:
+-------------------------------------------------------------+
| [ General ]          [ Condition ]             [ Top ]      |
|                                                             |
| Select members       By field: SUM(Sales) >= 50000          |
| from a list, or      OR                                     |
| choose 'Use all'     By formula:                            |
|                      SUM([Profit]) / SUM([Sales]) > 0.15    |
+-------------------------------------------------------------+

• The Condition Tab: Allows filtering membership based on an aggregated field threshold (e.g., SUM([Sales]) >= 100000) or a custom calculation formula (e.g., SUM([Profit]) / SUM([Sales]) > 0.20). Note that formulas written inside the Condition tab must be aggregated.
• The Top Tab: Allows defining membership based on the Top or Bottom $N$ members by an aggregated measure (e.g., Top 50 Customers by SUM([Sales])). The $N$ value can be hardcoded or dynamically linked to an integer Parameter.

[!NOTE] Order of Operations Context: Dynamic Sets evaluate in Step 4 of Tableau's Order of Operations. Therefore, their condition or Top N rules evaluate across all records within the data source (or Context Filter subset), ignoring standard Dimension Filters.

---

Combined Sets: Venn Diagram Logic

When sophisticated cohort analysis requires evaluating multiple criteria simultaneously, Tableau allows authors to combine two existing sets into a single Combined Set.

Prerequisites for Combined Sets

To combine two sets, both sets must be built on the exact same underlying dimension. For example, you can combine a set of Top 20 Customers by Sales with a set of Top 20 Customers by Profit because both share [Customer ID] as their root dimension. You cannot combine a set built on [Customer ID] with a set built on [Product Name].

The Three Combination Modes

Tableau provides three set combination operations, mirroring classic set theory and relational joins:

1. All Members in Both Sets (Union):
   [  Set A  (  A + B  )  Set B  ]  --> Returns all members from Set A or Set B.

2. Shared Members in Both Sets (Intersection):
   [  Set A     ( B )     Set B  ]  --> Returns only members present in BOTH sets.

3. Except Members (Left Difference / Anti-Join):
   [  Set A ( A ) [   ]   Set B  ]  --> Returns members in Set A that are NOT in Set B.

1. All Members in Both Sets (Union): Includes any dimension member that is present in Set A, Set B, or both. Useful for answering: "Which customers are either high-volume buyers OR highly profitable buyers?"
2. Shared Members in Both Sets (Intersection): Includes only dimension members that satisfy the criteria of both Set A AND Set B simultaneously. Useful for answering: "Which customers are both Top 50 in revenue AND Top 50 in profit?"
3. Except Members (Left Anti-Join / Difference): Includes dimension members that belong to the primary set but excludes anyone belonging to the secondary set (Set A EXCEPT Set B). Useful for answering: "Which high-volume customers (Top 50 Sales) generate unacceptable returns (NOT in Top 50 Profit)?"

---

Set Actions on Dashboards

Introduced in Tableau 2018.3, Set Actions transform static dashboard reporting into dynamic, interactive analytical applications. A Set Action allows user interactions on a worksheet (such as clicking a bar, hovering over a scatter mark, or selecting a lasso region) to inject the selected dimension members directly into a target Set.

Configuration Parameters

When configuring a Set Action (Dashboard > Actions > Add Action > Change Set Values), the author specifies:

• Source Sheets: The worksheet(s) where user interaction occurs.
• Run Action On: The trigger event: Hover, Select (click), or Menu (tooltip hyperlink).
• Target Set: The specific data source and Set to be modified.
• Clearing the Selection Will: Dictates what happens when the user deselects or clicks into empty whitespace:
  1. Keep set values: The set retains the last selected members.
  2. Add all values to set: Every member of the dimension is moved into the IN set.
  3. Remove all values from set: The set clears completely; all members become OUT.

Key Use Case 1: Asymmetric Drill-Down

In traditional Tableau hierarchies, expanding a dimension hierarchy (e.g., Category -> Sub-Category) expands every category across the entire table, generating hundreds of rows and causing visual overload.

With Set Actions, authors build an Asymmetric Drill-Down:

1. Create a Set on [Category] (initially empty).
2. Create a calculated field for the secondary shelf:

   // Calculated Field: [Dynamic Sub-Category]
   IF [Category Set] THEN [Sub-Category] ELSE '' END
   

3. Place [Category] and [Dynamic Sub-Category] on the Rows shelf.
4. Add a Set Action on the dashboard where selecting a Category updates [Category Set].
5. Result: When the user clicks 'Technology', only the Technology row expands into Phones, Machines, and Accessories. Furniture and Office Supplies remain neatly collapsed as single rows.

Key Use Case 2: Proportional Brushing

Proportional brushing visualizes the proportion of a whole that a selected subset represents across multiple disparate charts. For example, selecting a cluster of customers on a scatter plot immediately highlights their proportional sales contribution across various regional bar charts in bold color, while leaving the unselected cohort visible in muted gray.

---

Sets vs. Groups: The Definitive Comparison

A perennial examination topic is contrasting Tableau Sets with Tableau Groups:

---

Exam Traps & Practical Scenarios

• Exam Trap: Combining Sets Across Different Dimensions: A question may describe an analyst attempting to combine a Top 10 Products set with a Top 10 Customers set. Tableau strictly prohibits this; the 'Create Combined Set' menu option is grayed out unless both sets originate from the exact same dimension field.
• Exam Trap: Aggregation in Dynamic Set Formulas: When writing a formula in the Condition tab of a Dynamic Set (e.g., SUM([Profit]) > 0), the formula must be aggregated. Writing [Profit] > 0 generates a syntax error stating that the condition formula must be an aggregate comparison.
• Exam Trap: Using Groups When Business Rules Require Maintenance-Free Updates: If an exam scenario states that a company frequently adds new product lines and needs them to automatically categorize based on naming patterns or sales thresholds without manual report maintenance, Groups are the wrong answer. A calculated field (using IF or REGEXP) or a Dynamic Set must be used, because Groups require manual assignment of new dimension members.

---

Bins and Hierarchies

Bins group a continuous numeric measure into equal-width intervals, making them useful for histograms and distribution analysis. Create a bin from a numeric field and choose a size such as 10; Tableau produces ranges such as 0–9 and 10–19. A parameter can supply the bin size for interactive exploration. Bins describe numeric ranges, whereas groups consolidate selected dimension members and sets divide members into dynamic IN and OUT populations.

A hierarchy defines an ordered drill path. Drag a detailed dimension onto a broader dimension, or choose Create > Hierarchy, then order fields from broad to detailed—for example Category, Sub-Category, Product Name. The plus and minus controls expand or collapse levels in a view. A hierarchy organizes navigation; it does not enforce referential integrity or row-level security.