Study guide

7.2 Sets, Set Actions & Combined Sets vs. Groups

Salesforce Certified Tableau Data Analyst Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Connecting to Data & The Logical Data Model

1.1 Data Connections: Live Connections vs. Hyper Extracts 1.2 The Tableau Data Model: Relationships vs. Physical Joins 1.3 Combining Data: Data Blending vs. Cross-Database Joins

2 Chapter 2: Tableau Prep Builder & Data Wrangling

2.1 Tableau Prep Architecture & Data Cleaning 2.2 Reshaping Data in Prep: Pivots, Splits & Wildcard Unions 2.3 Joins, Aggregations & Output Destinations in Prep

3 Chapter 3: Data Quality, Metadata & Field Configuration

3.1 Data Types, Roles, Organization & Default Properties 3.2 In-Desktop Data Cleaning: Splits, Data Interpreter & Source Replacement 3.3 Managing Slowly Changing Dimensions & Data Quality Warnings

4 Chapter 4: Tableau Fundamentals & Calculations

4.1 Dimensions vs. Measures & Discrete vs. Continuous 4.2 Mastering Dates: Discrete Date Parts vs. Continuous Date Truncations 4.3 Calculations: Logic, Strings, Nulls & Type Conversion 4.4 Aggregation Rules, Granularity & Dealing with the Asterisk (ATTR)

5 Chapter 5: Level of Detail (LOD) Expressions

5.1 Level of Detail Architecture & Scoping Syntax 5.2 FIXED LOD Expressions: Scoping & Baseline Benchmarks 5.3 INCLUDE & EXCLUDE LOD Expressions: Dynamic Granularity 5.4 Real-World LOD Patterns: Cohorts, First/Last Dates & Binning

6 Chapter 6: Table Calculations & Directionality

6.1 Table Calculation Mechanics: Addressing vs. Partitioning 6.2 Essential Table Calculations: Running, Window & Percent of Total 6.3 Navigation & Ranking Functions: LOOKUP, INDEX & RANK 6.4 Secondary & Nested Table Calculations: Multi-Level Scoping

7 Chapter 7: Statistical Analytics, Filtering & Order of Operations

7.1 The Tableau Order of Operations: From Extract to Display Filters 7.2 Sets, Set Actions & Combined Sets vs. Groups 7.3 Parameters, Parameter Actions & Dynamic What-If Analysis 7.4 Analytics Pane: Totals, References, Trends & Forecasts

8 Chapter 8: Chart Types & Comparative Visualizations

8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs 8.2 Part-to-Whole & Correlation Charts: Treemaps, Scatter Plots & Bubbles 8.3 Trend & Distribution Visualizations: Dual-Axis, Combos & Histograms

9 Chapter 9: Advanced Visualizations & Spatial Analysis

9.1 Specialized Visualizations: Waterfall, Gantt, Sparklines & Bump Charts 9.2 Spatial Data & Mapping: Geographic Layers & Spatial Functions 9.3 Visual Polish: Custom Palettes, Annotations & Viz in Tooltip

10 Chapter 10: Dashboard Design & Interactive Actions

10.1 Dashboard Layout, Devices & Visibility 10.2 Filter, Highlight & URL Actions 10.3 Advanced Interactivity: Parameter, Set & Navigation Actions 10.4 Stories & Visual Storytelling: Sequencing Analytical Narratives

11 Chapter 11: Tableau Server & Cloud: Architecture & Publishing

11.1 Tableau Server & Cloud: Sites, Projects, Roles & Permissions 11.2 Publishing Workbooks, Data Sources & Flows

12 Chapter 12: Data Governance, Security & Operations

12.1 Certification, Data Quality, Lineage & Permissions 12.2 Row-Level Security, Schedules, Subscriptions & Alerts

7.2 Sets, Set Actions & Combined Sets vs. Groups

Key Takeaways Explain This Topic AI

Sets are custom fields that define subsets of data based on specific conditions, segmenting records into a binary IN/OUT boolean membership.

Fixed (static) sets are created from manual mark selections and remain completely static, failing to capture new or changed records when data refreshes.

Dynamic sets evaluate membership dynamically based on single-field conditions or Top/Bottom thresholds, re-evaluating automatically upon data updates.

Set Actions allow dashboard users to interactively update set membership by clicking, hovering, or selecting marks, powering asymmetric drill-down and proportional brushing.

Combined Sets merge two existing sets built on the same dimension using Union, Intersection, or Difference, whereas Groups only merge static values and lack dynamic formula support.

Last updated: September 2026

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 N N members by an aggregated measure (e.g., Top 50 Customers by SUM([Sales]) ). The N N 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.

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?"

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?"

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:

Keep set values: The set retains the last selected members.

Add all values to set: Every member of the dimension is moved into the IN set.

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 :

Create a Set on [Category] (initially empty).

  • Create a calculated field for the secondary shelf: // Calculated Field: [Dynamic Sub-Category]
  • IF [Category Set] THEN [Sub-Category] ELSE '' END

Place [Category] and [Dynamic Sub-Category] on the Rows shelf.

Add a Set Action on the dashboard where selecting a Category updates [Category Set] .

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 :

Feature / Capability Tableau Sets Tableau Groups

Core Purpose Isolate cohorts for comparison ( IN / OUT ) Combine discrete categorical values into higher-level buckets

Dynamism Dynamic or Static: Can adapt automatically via rules or Top N Strictly Static: Hardcoded member assignments; never dynamic

Formula Support Yes: Condition tab supports aggregated boolean formulas No: Cannot be driven by formulas or calculations

Order of Operations Evaluates at Step 4 (before dimension filters) Evaluates at Step 5 (as a standard visual dimension)

Dashboard Actions Yes: Fully supported via native Set Actions No: No native 'Group Actions' exist in Tableau

Combined Operations Yes: Supports Union, Intersection, and Difference No: Groups cannot be combined mathematically

Parameter Integration Yes: Top N can be driven directly by an Integer Parameter No: Parameters cannot drive group membership

  • Data Types Supported Created on any discrete dimension Created on any discrete dimension
  • Output Structure Returns boolean membership ( IN or OUT ) Returns custom string alias labels for grouped items
  • 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.

Loading diagram... Set Architecture: Dynamic Generation, Set Actions & Combined Set Logic