How to Create a Group in Tableau

Grouping data in Tableau is a simple way to combine related members in a dimension. This helps you simplify complex visuals, clean up messy data, and create custom categories on the fly. This article will walk you through exactly how to create and manage groups in Tableau, step-by-step, with practical examples to guide you.

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

What Are Groups in Tableau?

At its core, a group is a custom field that combines multiple dimension members into a single, higher-level category. For example, if you have a list of all 50 U.S. states in a dimension, you could group them into regions like "West Coast," "East Coast," and "Midwest." You aren't changing your original data source, you're just creating a new, simplified dimension within Tableau for better analysis.

This is commonly used for a few key reasons:

• Simplifying Your View: When you have too many categories, a chart can become cluttered and hard to read. Grouping condenses these categories into a more manageable number, making your visualizations much cleaner.
• Cleaning Messy Data: Data entry isn't always perfect. You might have fields with variations like "USA," "U.S.," and "United States." Creating a group allows you to combine all these variations into a single, consistent member without having to edit the source data directly.
• Creating High-Level Segments: You can create custom segments that don't exist in your data. For example, you could group underperforming products into a "Watch List" category and star products into a "Top Performers" list to compare their performance against everything else.

Now, let's get into the different ways you can create groups in your Tableau workbook.

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

Method 1: Creating a Group from the Data Pane

This is the most straightforward method for creating a group when you already know which members you want to combine. It involves selecting them directly from the dimension in the Data pane.

Let's use the sample "Superstore" dataset that comes with Tableau. Imagine we want to group several sub-categories of products into larger segments.

Step-by-Step Instructions:

1. Find your dimension: In the Data pane on the left side of your screen, locate the dimension you want to work with. For this example, we'll use Sub-Category.
2. Open the Create Group dialog: Right-click on the Sub-Category dimension, navigate to Create, and then select Group...
3. Select and group members: A new window will pop up, listing all the members within the "Sub-Category" dimension.
4. Rename your group: By default, Tableau will name the new group by concatenating the names of its members (e.g., "Bookcases, Chairs, Furnishings, & Tables"). This is not very readable, so you should give it a better name. Right-click on the new grouped field in the dialog and select Rename. Let's call it Furniture.
5. Create more groups (optional): You can repeat this process within the same window. For instance, you could select "Appliances," "Copiers," "Machines," and "Phones" and group them into a new category called "Electronics."
6. Use the 'Other' group (optional): At the bottom of the dialog box, you'll see a checkbox labeled Include 'Other'. If you check this, Tableau will lump all the members you didn't add to a group into a default category named "Other." This is useful for isolating specific groups and comparing them to everything else.
7. Save your group: Once you're finished, click OK. You’ll now see a new field in your Data pane called Sub-Category (group), indicated by a paperclip icon. You can drag and drop this field into your view like any other dimension.

Method 2: Visual Grouping from a Chart

Often, the need to create a group becomes obvious once you've already built a visualization. Tableau allows you to create groups directly from your view (a chart, map, or table) by selecting the marks themselves. This method is fast, intuitive, and great for quick data exploration.

Let’s say you've built a bar chart showing Sales by Sub-Category, and you notice several smaller categories you want to combine to simplify the visual.

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

Step-by-Step Instructions:

1. Create a Visualization: First, build a simple chart. Drag Sub-Category to the Columns shelf and Sales to the Rows shelf. Sort it descending to see the top-performing categories easily.
2. Select the Marks: Identify the marks (the bars, in this case) you want to group. Hold the Ctrl key (or Cmd on a Mac) and click on each bar you want to combine. Alternatively, you can click and drag your cursor to draw a box around the bars. Let's select "Fasteners," "Labels," and "Supplies."
3. Group the Members: Once the marks are highlighted, hover over one of them until the tooltip toolbar appears. Find the paperclip icon, which represents the "Group" command, and click it.
4. Tableau Does the Rest: The magic happens here. Tableau instantly performs three actions:

You can now right-click the new group field in the Data pane to edit its name or adjust its members as needed.

How to Edit an Existing Group

Creating a group is just the first step. You'll often need to modify it by renaming groups, moving members around, or adding new ones. Editing groups is straightforward.

1. Locate and open the group: In the Data pane, find the grouped field (the one with the paperclip icon). Right-click on it and select Edit Group...
2. Make your changes: The "Edit Group" window will open, identical to the "Create Group" window. From here, you can perform several actions:
3. Apply the changes: Click OK to save your modifications. Any visualizations using this group will update automatically.

Groups vs. Sets vs. Bins: A Quick Comparison

New Tableau users often get confused about the differences between groups, sets, and bins. All three are used for categorization, but they serve different purposes. Here's a quick breakdown:

Groups

• What they do: Combine multiple dimension members into a single, static category. For example, grouping "Washington," "Oregon," and "California" into a "West Coast" group.
• Based on: A static, manual selection of dimension members.
• Use case: Simplifying dimensions with many members or cleaning up messy data entries. It creates a new dimension.

Sets

• What they do: Create a custom field that separates members into two categories: "In" or "Out." For example, a set of your "Top 10 Customers by Sales."
• Based on: Can be static (like a group) or dynamic (based on a condition, formula, or top N filter). Dynamic sets update automatically as your data changes.
• Use case: Powerful for comparisons and complex calculations where you need to isolate or compare a specific subset of data against the rest.

Bins

• What they do: Take a measure (a numeric field) and create equal-sized intervals or "buckets." For example, grouping an "Age" field into bins like 0-10, 11-20, 21-30.
• Based on: A continuous measure. You cannot create bins from a dimension.
• Use case: Primarily used for creating histograms to see the distribution of a numeric value.

The key takeaway is this: use groups to combine static dimension members, use sets for dynamic or conditional "In/Out" comparisons, and use bins to segment continuous measure values.

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

Final Thoughts

Grouping in Tableau is an essential skill for cleaning and simplifying your data. By combining members from a dimension, you can transform a cluttered, complicated visualization into a clear and insightful one, allowing you to tell a more compelling story with your dashboard.

Manually creating groups and reports in BI tools is powerful but often involves many manual steps. We built Graphed to eliminate the hours spent on this kind of manual reporting. Instead of clicking through menus to group data and build charts, you can ask questions in plain English. For example, tell Graphed to "Show me my sales, but group my top 5 product categories and lump the rest into 'Other'," and it instantly builds a live, interactive dashboard, keeping everything updated in real-time directly from your data sources.