EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials Tableau Tutorial Tableau Group by
 

Tableau Group by

Priya Pedamkar
Article byPriya Pedamkar

Tableau Group by

Introduction to Tableau Group By

Group By the name itself define activity done by the visualization. Grouping of the similar or the different measures and dimensions. We can combine the groups of similar or related members in the tableau field. We can create a group for the categories or the countries. Suppose we have started doing visualization with sample superstore database, we can create a group for the dimensions like category, sub-category and measures like profit (average profit), etc. It will be used for correcting data errors and answering questions like what if. What if is nothing but the what-if group states.

 

 

Syntax

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

There is no formula like syntax present for the group in the visualization but there are steps to be performed. Got to dimension or measure field -> right click on the field->create->group

How does Group by done in Tableau?

  1. we have imported sample – superstore database into tableau.
  2. We have dragged the order table into the sheet.

We will create a group by dimension.

  1. Go to the category dimension ->right click->create a group

Tableau Group by 1

  1. Select the choices from the field category and click on the group. We have group Furniture and Office Supplies.

Tableau Group by 2

  1. Group has been created in the dimension field.

Tableau Group by 3

  1. We can add category (group) to the Filters and can see group values. We can see that Furniture and Office Supplier has been grouped.

Tableau Group by 4

Example of Tableau Group by

  1. We have again created a group for the city dimension. We have grouped Aberdeen, Abilene, Akron city and selected random cities. To see this data we need to drag the city(group) to the Filters.

group for the city dimension

  1. We can create a group for the dimension field also. The created group will be reflected in the Dimension field.
  2. We have created a group for the discount and selected only 0.1, 02 and 0.3 and the last 0.149 values as a discount.

discount and selected

We can create groups with remaining choices or items, and we can include this created groups while creating a new one or adding one or another. Including other groups will help us to highlight major and minor points of the data or to show differentiation of the result (group members).

Working of Tableau Group by

  1. Go to the category group->right click->edit group->mark include other

category group

  1. We can observe in the below image, other which is nothing, but the office category has been added to the group (by using include other choices).

office category

We are going to see profit and sales for the category group like how each measure has performed for the category dimension.

  1. Drag profit to column and sales to rows.
  2. Drag category group to the Filters.
  3. Select all option from the Filter window.
  4. For editing purpose change color of the category group (click on color->select color of your choice)

You can observe in the below image how data is displayed in the tableau group by the view.

data is displayed in the tableau group

We have the Edit option for the group by data. Editing option, we can use to change the group name as per our choice, add and remove other choices of the filed, create a new group. We need to use the edit group option always while making changes in the group.

  1. We can rename the group as we want to frame it. We are going to perform these tasks for the state(group).
  2. Right-click on the state(group) -> window will option we can rename it. You can observe in the below image how renaming is affected.

Right-click on the state(group)

  1. Or we can rename the group in another way.
  2. Right click on the group -> click on rename option -> name it.

Right click on the group

  1. We can observe in the below image the result of the renaming in another way.

renaming in another way

  • We can add members to the group or remove it through the edit group option.
  1. Go to the group you want to edit with.
  2. Right-click on the group -> edit group->click on the group icon
  3. The select member you don’t want to group with – > click on Ungroup.

You can observe in the below image Akron city has been removed from the group.

Akron city has been removed

  • For adding purpose follow the main step of adding a member to the group.

Select member -> click on Group option.

  • We can color the group as per our wish, drag group to the color section.

drag group to the color section

Conclusion

We have understood what is the group by, how it should be done and what choices it offers and how this will help us to get more detailed of the data or comparison of the data. It is easy to do editing with the data such as color, rename, size or shape of the data. Grouping will help us to find out how data is increasing and decreasing in terms of performance. If we create a group by of the measure, then resulted group is reflected in the dimension field.  

 Recommended Articles

This is a guide to Tableau Group by. Here we discuss how does Group by done in Tableau along with the working and examples. You may also have a look at the following articles to learn more –

  1. Tableau Count Distinct
  2. Tableau Fixed Function
  3. Legend in Tableau
  4. Tableau Dual Axis
  5. Guide to Window Sum Tableau
  6. Tableau Order of Operations
  7. Tableau User Group | How to Create?

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Limited Time Offer! - ENROLL NOW