Sets for dynamic grouping in Tableau - Step-by-Step Guide

Introduction

Sets in Tableau let you group data dynamically based on conditions or user choices. This helps you analyze specific parts of your data easily without changing the original data source.

When you want to compare sales of top 10 customers against others without changing the data.

When you need to highlight products that meet certain criteria like high profit or low sales.

When you want users to select which regions to focus on in a dashboard.

When you want to create a group that updates automatically as data changes.

When you want to filter or color code data points based on dynamic groups.

Steps

Step 1: Right-click

- a dimension field in the Data pane

A menu appears with options related to the field

💡 Choose a field that you want to group dynamically, like Customer Name or Product Category

Step 2: Select

- Create > Set

The Create Set dialog box opens

💡 This dialog lets you define which members belong to the set

Step 3: Choose

- General tab in the Create Set dialog

You see a list of all members of the field

💡 You can select members manually or use conditions

Step 4: Click

- Condition tab

You can define a rule to include members dynamically

💡 For example, set sales greater than 10000 to include only high sales customers

Step 5: Click

- OK button

The set is created and appears in the Data pane under Sets

💡 You can now drag this set to Filters, Color, or Rows/Columns

Step 6: Drag

- the created set to the Filters shelf

The view updates to show only data in the set

💡 Use this to focus your analysis on the dynamic group

Before vs After

Before

The view shows all customers with their sales data

After

The view shows only customers with sales greater than 10000 as defined by the dynamic set

Settings Reference

General tab

📍 Create Set dialog

Choose specific members to include in the set

Default: No members selected

Condition tab

📍 Create Set dialog

Define dynamic rules to include members based on data values

Default: No condition

Top tab

📍 Create Set dialog

Select top or bottom members based on a measure like sales

Default: No top members selected

Common Mistakes

Selecting members manually and expecting the set to update automatically

Manual selection does not change when data changes

Use the Condition or Top tab to create dynamic rules for the set

Dragging the set to the wrong shelf like Marks instead of Filters

The set will not filter or group data as expected

Drag the set to Filters or use it on Color or Rows/Columns shelves for grouping

Summary

Sets let you create dynamic groups in Tableau based on conditions or selections.

You can create sets manually or with rules that update as data changes.

Use sets to filter, color, or group data easily without changing the original data.