How Tableau Prep Decides Default Group Names

A fundamental component of Tableau Prep is the ability to clean messy data. One of the best ways to do that is by creating groups! However, creating groups can be confusing. How does Tableau Prep decide what to name a group? For example, if you group "Boise" and "Boise City" together into a single city name, which does Tableau Prep choose? Well, that all depends on the grouping method you select.
If you use automated groups (grouping on pronunciation, common characters, etc.) it will choose the more populous value. So if there are 100 rows for "Boise" and 5 rows for "Boise City", the group name will default to "Boise".
If you create selection groups in the clean step (using CTRL and SHIFT) the group name will be whichever value you selected last before selecting "Group".
If you use the "Manual Grouping" feature in the grouping dialogue, it will be whichever value you selected first.
Are you thoroughly confused yet?!?
Check out this video to see a run through of a couple grouping approaches and which group name Tableau Prep takes.
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Resources:
•Identify and Modify Grouped Values in Tableau Prep: onenumber.biz/blog-1/2021/9/5...
•Do Tableau Prep groups automatically incorporate new values?: • Do Tableau Prep Groups...
Chapters:
0:00 Background
0:44 Automated Grouping
1:43 Selection Grouping
1:58 Upcoming Tableau Classes
2:19 Selection Grouping Continued

[@onenumbertableau]

Need help with Tableau Prep? Schedule an hour with Eric here: onenumber.biz/office-hours
Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes