EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Group in Tableau
Secondary Sidebar
Tableau Tutorial
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Group in Tableau

By Priya PedamkarPriya Pedamkar

Group in Tableau

Introduction to Group in Tableau

In the article Group in Tableau, the group is a feature by which we can combine multiple dimension values into desired categories. Sometimes we may have numerous values for a dimension. Driving visual analytics over such a number of dimension values may not be feasible as it may not convey any useful insights. However, a combination of different dimensions values based on some similarities between them can allow us to create groups that we can use for analysis. These groups will convey insights in a much better manner than what the individual dimension values would have otherwise conveyed. The “Group” in Tableau is thus a very useful feature.

Creating Groups in Tableau

For this demonstration, we are using the Regional Sales dataset. The dataset contains quarter wise sales by different sales units in India. Here, important dimensions are the Sales Unit and Quarter, while Sales is a measure. Twenty major Indian cities represent different sales units across the country. We want to understand the regional contribution as against sales unit contribution in total sales. However, we don’t have a region as a dimension in the dataset. So, we’ll apply the concept of “Groups” to achieve the target.

Step-by-step procedure to create groups 

1. Load the dataset into Tableau. For this click on “New Data Source” under the Data menu. Alternatively, click on “Connect to Data”.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Connect to Data

2. Next, select the requisite data source type. In this case, the data source type is MS Excel, so we selected Microsoft Excel.

Requisite Data Source Type

3. The data gets loaded into Tableau and can be seen in the “Data Source” tab as shown by the below screenshot. Note, the data must be verified prior to proceeding to the analysis.

Data Source

4. Moving to the sheet tab, we can find the dimensions DU Code, Quarter, and Sales Unit, and the measure Sales present in the requisite sections.

Sales Unit

5. As a first step, just double click the over-dimension Sales Unit and measure Sales. The automatically Sales Unit goes into the Rows region. As we can see, we get a table giving Sales figures by Sales Units.

over-dimension Sales Unit

6. We converted the above table into a vertical bar graph, which conveys the insights in a better way. However, the data is present in the Sales Unit wise. In order to understand the regional performance of sales, we need to have regions in the analysis. Moreover, trying to interpret regional performance through sales units is quite difficult. So, in order to get the region as a dimension into the analysis, we will create groups of dimension values.

Here, different sales units belong to different regions. Some belong to the East, some to South, etc. So, based on the geographical location of the sales units, we’ll classify them into five groups namely East, West, North, South, Central. When we incorporate this region dimension into the analysis, we’ll be able to have a panoramic view of the sales performance across the entire network.

group in tableau ss 6 PNG

7. To create the groups, click on the drop-down menu of the dimension whose values we want to combine into groups. In this case, the dimension is Sales Unit, so, in its drop-down menu, in “Create”, select Group, and click on it. This is illustrated in the below screenshot.

Dimension is Sales Unit

8. A “Create Group” dialogue box appears, as shown below. In this dialogue box, we can select desired dimension values to create a particular group.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,650 ratings)

Desired Dimension values

9. To create the first group, we selected Ahmedabad, Mumbai, Nasik, Pune, and Surat by pressing Ctrl, as shown in the below screenshot. Then clicking on Apply generated the group. The group has been named as “West” denoting the West region as shown by the screenshot subsequent to the below one.

Denoting the West region

Sales Unit Group

10. Following the above procedure, we created a second group which is “South” containing Bengaluru, Hyderabad, Kozhikode, and Vizag as shown below.

group in tableau ss 10 PNG

11. The third group we created consists of Bhopal, Delhi, Jaipur, and Varanasi. All these belong to North India, so, we named the group “North”.

group in tableau ss 11 PNG

12. Last but one, we created the “East” region following the very same process, which is composed of Bhubaneshwar, Guwahati, Kolkata, and Patna. This is as shown by the below screenshot.

group in tableau scrn 12 PNG

13. Lastly, we create the “Central” region which contains Nagpur and Raipur.

sales unit group

14. We successfully managed to create groups representing different regions containing different sales units. However, as can be seen in the above screenshot, we forgot to include Rajkot in a particular group. Rajkot is located on the west and so must be included in the “West” group. To include it, right-click on Rajkot, and then click on “Add to” as shown below. Now, as shown in the screenshot subsequent to the below one, from the list of Regional groups, select “West” and click on OK.

sales unit group

sales unit group

15. Following the above procedure just familiarized us with another approach to add values to a group. And we can see, now, Rajkot appears under West.

group in tableau ss 15PNG

16. These groups will now act as dimension values for a newly created dimension. We must give it an appropriate name. So, in the “Field Name” section, we named it “Region”. Finally, click on Apply and then on OK. This is as illustrated in the below screenshot.

sales unit group

17. As we can see now, the newly created field as dimension appears in the dimension section. Now, we can very well use it in the analysis. Note, the dimension Region will not affect the dataset but only facilitate visual analysis at the view level. So, by combining different dimension values, we can create an effective visual analysis based on the need, without affecting the original data.

group in tableau ss 17PNG

18. The following screenshot gives us a closer look into the newly created dimension Region containing various groups as values.

group in tableau ss 18PNG

19. We included the dimension Region into the analysis, and sorting the result in the descending order of sales generated the following analysis. The following bar chart gives us a direct insight into regional sales performance.

group in tableau ss 19 PNG

Conclusion- Group in Tableau

In certain situations, requisite data might be present in the dataset but not in the way we wanted it to be. However, through a combination of different dimension values, we may obtain a new dimension convenient for analysis. Tableau facilitates the user to apply this approach through the functionality of Groups.

Recommended Articles

This has been a guide to Group in Tableau. Here we also discuss the introduction and creating Group in Tableau. You may also have a look at the following articles to learn more–

  1. Tableau Aggregate Functions
  2. Tableau Data Sets
  3. What is Tableau Dashboard?
  4. Creating Set in Tableau
  5. MySQL Aggregate Function | Top 10
  6. Concatenate in Tableau | How to Use?
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more