Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Creating Groups in Tableau

Learn how to combine related dimension members into meaningful categories using Groups in Tableau. Understand manual grouping, grouping marks, editing groups, handling ungrouped values and creating business-friendly categories for data analysis.

1. Introduction to Groups in Tableau

Groups in Tableau allow users to combine multiple dimension members into a single category. This feature is useful when different values in a dataset belong to the same logical or business category.

For example, a company may have several product names that belong to broader product categories. Instead of analyzing every individual product separately, users can group related products together.

Groups help simplify data analysis, reduce unnecessary categories and make visualizations easier to understand. They are especially useful when the original dataset contains many dimension members that need to be presented as a smaller number of meaningful categories.

Why are Groups useful?

  • Combine related dimension members.
  • Reduce the number of categories in a visualization.
  • Create business-friendly classifications.
  • Improve chart readability.
  • Compare combined categories instead of individual members.
  • Support customized data analysis without modifying the original source data.

2. Understanding Groups with an Example

Consider a sales dataset containing different product sub-categories. The company wants to combine related products into larger business groups for reporting.

Original Dataset

Product Sub-Category Sales
Phones45,000
Accessories30,000
Chairs25,000
Tables20,000
Binders18,000
Paper12,000

We can create groups such as Technology, Furniture and Office Supplies by combining related sub-categories.

Grouped Dataset

Product Group Included Sub-Categories
Technology Phones, Accessories
Furniture Chairs, Tables
Office Supplies Binders, Paper
Grouping Product Sub-Categories Original Values Phones Accessories Chairs Tables Group Grouped Categories Technology Furniture Office Supplies
Illustrative example showing how multiple sub-categories can be combined into larger groups.

3. How Groups Work in Tableau

A group is created from members of a dimension. Users select one or more dimension members and combine them into a new group. Tableau creates a grouped field that can be used in worksheets like other dimensions.

For example, if a Region dimension contains East, West, Central and South, users can combine East and West into a group called Northern Markets and Central and South into another group called Southern Markets.

Important Group Concepts

Concept Description
Dimension Member An individual value within a dimension, such as East or West.
Group A collection of selected dimension members.
Grouped Field A new field created by combining dimension members into groups.
Group Name The name assigned to a collection of dimension members.
Other Group An optional category that can contain dimension members not assigned to named groups.
Important: Groups are created from dimension members. They are not the same as calculated fields or sets, although these Tableau features can all help organize and analyze data.

4. Creating Groups Manually in Tableau

Manual grouping allows users to select specific dimension members and combine them into a custom category. This is useful when the grouping rules are based on business knowledge rather than a fixed numeric condition.

Example: Grouping Regions

Suppose a company wants to combine its four regions into two business zones:

Original Region New Group
EastZone A
WestZone A
CentralZone B
SouthZone B

Steps to Create a Group from the Data Pane

  1. Open Tableau Desktop or Tableau Public.
  2. Connect to a dataset containing a suitable dimension.
  3. Locate the dimension in the Data Pane.
  4. Right-click the dimension.
  5. Select Create and then Group.
  6. The Group dialog box opens.
  7. Select the dimension members that should belong together.
  8. Click Group to combine the selected members.
  9. Rename the new group with a meaningful business name.
  10. Repeat the process for other required groups.
  11. Click OK to save the grouped field.

Using the Grouped Field

After creating the group, Tableau adds a new grouped dimension to the Data Pane. Users can drag this field into Rows, Columns, Color, Filters or other supported worksheet locations.

Tip: Give groups meaningful names such as North Zone, South Zone, Premium Products or Budget Products instead of leaving generic names that are difficult to understand.

5. Creating Groups by Selecting Marks

Tableau also allows users to create groups directly from selected marks in a visualization. This approach is useful when users are exploring a chart and identify categories that should be combined.

For example, a bar chart may display multiple product sub-categories. Users can select related bars and combine them into a group.

Steps to Group Selected Marks

  1. Create a visualization such as a bar chart.
  2. Place the required dimension on the view.
  3. Display a measure such as Sales to create the marks.
  4. Select the marks that should be combined.
  5. Use the Group option available from the selection toolbar or context menu.
  6. Tableau combines the selected dimension members.
  7. Rename the resulting group if required.
  8. Review the chart to confirm the grouping.
Grouping Selected Marks Phones Accessories Chairs Tables Technology Phones + Accessories
Illustrative example of selecting marks and combining their dimension members into a group.
Note: The exact selection toolbar and context-menu options can vary with the view and Tableau version. The Group action is available when the selected marks represent compatible dimension members.

6. Editing and Managing Groups

After creating a group, users may need to update its name, add additional members, remove members or reorganize categories. Tableau provides options to manage groups through the grouped field in the Data Pane or through the worksheet.

Common Group Management Operations

Operation Purpose
Rename Group Changes the display name of a group.
Add Members Includes additional dimension members in a group.
Remove Members Removes selected dimension members from a group.
Ungroup Returns selected grouped members to their individual values.
Edit Group Opens group settings to modify its member assignments.
Delete Group Field Removes the grouped field from the workbook.

Steps to Edit an Existing Group

  1. Locate the grouped dimension in the Data Pane.
  2. Right-click the grouped field.
  3. Select Edit Group.
  4. Review the existing group names and assigned members.
  5. Add or remove members as required.
  6. Rename groups when necessary.
  7. Click OK to apply the changes.
  8. Review the worksheets that use the grouped field.
Best Practice: Review group membership whenever the business classification changes. This helps keep reports consistent with current reporting requirements.

7. Understanding the Other Group Option

The Other group option can be used to combine dimension members that are not assigned to the named groups into a single category. This is helpful when a dimension contains many members but only a few are important for individual analysis.

Example

Consider a product dimension with the following values:

Product Grouping
PhonesTechnology
AccessoriesTechnology
ChairsFurniture
TablesFurniture
BindersOther
PaperOther
LabelsOther

Here, Technology and Furniture are explicitly created groups. The remaining members can be displayed together in an Other category when the Other group option is enabled.

How to Use Other Group

  1. Create a group using the required dimension members.
  2. Open the grouped field's Edit Group dialog.
  3. Locate the Include Other option, when available.
  4. Enable the option to combine ungrouped members into Other.
  5. Click OK.
  6. Review the view to confirm how remaining members are displayed.
Important: Other is not a business classification automatically inferred by Tableau. It is a grouping option for members that are not assigned to the explicitly defined groups.

8. Difference Between Groups and Aliases

Groups and aliases both help organize how dimension values appear in Tableau, but they serve different purposes.

Feature Groups Aliases
Main Purpose Combines multiple dimension members into one category. Changes the displayed name of an individual member.
Number of Members Can combine multiple values. Changes the display label of a value.
New Grouped Field Creates a grouped dimension. Does not create a new grouped dimension.
Example East and West become Zone A. East is displayed as Eastern Region.
Typical Use Business segmentation and category consolidation. Improving labels and readability.
Remember: Use Groups when multiple values must become one category. Use Aliases when you only need to change how an individual value is displayed.

9. Difference Between Groups and Sets

Groups and Sets are both useful Tableau features for organizing and analyzing dimension members. However, groups combine members into named categories, while sets define a collection of members based on selected or rule-based membership.

Feature Groups Sets
Purpose Combines related dimension members. Defines a subset of dimension members.
Membership Members are assigned to named groups. Members belong to the set or remain outside it.
Creation Can be created through manual selection. Can be created through manual or condition-based selection.
Typical Output A grouped dimension. IN/OUT membership.
Example East and West combined as Zone A. Top-performing customers included in a set.

Groups are useful when the objective is to create business categories. Sets are useful when the objective is to identify and analyze a selected subset of data.

10. Practical Example: Create Product Groups

In this practical exercise, we will create product groups using a sales dataset. The objective is to combine individual product sub-categories into larger reporting categories.

Sample Dataset

Product Sub-Category Sales Profit
Phones45,0009,000
Accessories30,0006,000
Chairs25,0004,000
Tables20,0002,500
Binders18,0003,000
Paper12,0002,000

Step 1: Connect to the Dataset

  1. Open Tableau Desktop or Tableau Public.
  2. Connect to the sales dataset.
  3. Open a new worksheet.
  4. Review the Product Sub-Category dimension.

Step 2: Create Technology Group

  1. Locate Product Sub-Category in the Data Pane.
  2. Right-click the dimension.
  3. Select Create and then Group.
  4. Select Phones and Accessories.
  5. Click Group.
  6. Rename the group to Technology.

Step 3: Create Furniture Group

  1. In the same group dialog, select Chairs and Tables.
  2. Click Group.
  3. Rename the group to Furniture.

Step 4: Create Office Supplies Group

  1. Select Binders and Paper.
  2. Click Group.
  3. Rename the group to Office Supplies.
  4. Enable Other if you want any remaining ungrouped members combined into that category.
  5. Click OK to save the grouped field.

Step 5: Create a Sales Visualization

  1. Drag the newly created grouped field to Columns.
  2. Drag Sales to Rows.
  3. Select a Bar Chart if required.
  4. Drag the grouped field to Color if you want to distinguish categories.
  5. Display Sales values using Label.
  6. Rename the worksheet to Product Group Sales.

Expected Result

The resulting visualization should display aggregated sales for Technology, Furniture and Office Supplies rather than showing every individual sub-category separately. This makes the report easier to read and compare.

11. Real-World Business Use Cases

1. Sales Analysis

A sales team can group individual products into business categories such as Electronics, Furniture and Office Supplies to compare performance at a higher level.

2. Regional Reporting

Organizations operating in multiple locations can combine cities into larger operational zones to simplify regional reporting.

3. Customer Segmentation

Customer categories can be grouped into business-defined segments such as Retail Customers, Corporate Customers and Strategic Accounts when the dimension values support those classifications.

4. Financial Reporting

Financial reports can combine related expense categories into broader reporting groups such as Operations, Administration and Marketing.

5. Product Performance

Product sub-categories can be grouped into larger categories to compare revenue, profit and quantity across product families.

12. Common Mistakes While Creating Groups

Mistake Problem Recommended Practice
Grouping unrelated members Creates misleading business categories. Define a clear grouping rule before combining members.
Using unclear group names Makes reports difficult to understand. Use meaningful business-friendly names.
Ignoring ungrouped members Some values may not appear in the expected named groups. Review remaining members and decide whether to use Other.
Creating duplicate groups Can make the Data Pane confusing. Review existing grouped fields before creating new ones.
Not reviewing group membership Business classifications may become outdated. Update groups when reporting requirements change.
Confusing groups with sets Leads to incorrect analytical design. Understand the difference between grouping and subset membership.

13. Best Practices for Creating Groups

  • Understand the purpose of grouping before combining dimension members.
  • Use clear and meaningful group names.
  • Group members according to consistent business rules.
  • Review ungrouped members after creating groups.
  • Use the Other option when it makes the report easier to understand.
  • Keep the number of groups manageable.
  • Check how grouping affects chart totals and comparisons.
  • Update groups when business classifications change.
  • Use groups for category consolidation rather than replacing source data unnecessarily.
  • Document important grouping rules for report users.

Summary

Groups in Tableau allow users to combine related dimension members into meaningful categories for easier analysis and reporting. Users can create groups manually from the Data Pane or directly from selected marks in a visualization. After creating groups, they can rename them, add or remove members, edit group assignments and optionally combine remaining ungrouped members through the Other option. Groups are useful for product classification, regional reporting, sales analysis and business segmentation. Understanding the differences between Groups, Aliases and Sets helps users choose the appropriate Tableau feature for organizing and analyzing their data.