Tableau Groups vs Sets - Comparison and examples (proportional brushing, top and bottom values)
ฝัง
- เผยแพร่เมื่อ 27 ก.ค. 2024
- Tableau Groups vs Sets - This video provides a complete overview of groups and sets in Tableau. We will walk through how to create groups, fixed sets and dynamic sets. We will also look at some common use cases for each.
For shorcuts, please see: • 10 Tableau tricks you ...
Sections:
0:00 - Intro
1:13 - Groups
5:16 - Visual Grouping in Tableau
7:50 - Groups Use Case: keyword matching
10:18 - Sets
13:05 - Dynamic Sets
14:57 - Set Operations: Combining two sets
18:47 - Set Use Case 1: Show top and bottom values
20:36 - Set Use Case 2: Proportional Brushing
Related Videos:
Blue vs Green, Discrete vs Continuous
• Tableau Tutorial - Dim...
Useful Tableau Shortcuts
• 10 Tableau tricks you ...
Images courtesy of Unsplash, Pexels, Pixabay - วิทยาศาสตร์และเทคโนโลยี
![Tableau Group vs Set [What's the Difference between Tableau's Sets and Groups?]](/img/n.gif)
WOW, It was worth the wait! You clarified the difference between Groups and Sets in such a simple, yet comprehensive way! Looking forward for more such informative and super useful videos! Love the way you explain and teach, keep up the great work! 😊👍
Thank you Vijay!
Recommended for all Tableau developers. Very clear and thorough coverage of these important topics. Thank you again for sharing your insights.
Thank you so much Derek! Your feedback and comments are much appreciated! 🙂
So glad to have found your channel and see Filipina-canadian representation in the space. I loved reading your website and blogs.
Thank you so much Micha! I appreciate your kind words and support ❤️
How gracefully you have explained minute details in simplest way ! More power to you.
Thanks for such an incredible insights.
Thank you so much Gaurav! :)
Really nice video... Whenever I find any difficulty in tableau, i search for your video first... :)☺️
Thank you so much for sharing, Piyush! So happy to hear you are finding the channel helpful :)
I just passed the Tableau Desktop Specialist certification Exam...and i owe you big time... Thank you :)
Congratulations on the wonderful news, Tariq!
I've been using Tableau for several years yet I still learn things from your videos. I like the way you sometimes go off-topic to add some useful side notes such as you did for set controls in this vid. you obviously spend a great deal of time on your productions.
WOW! Almost two years using Tableau and just now realize what SETS can do 🤯
PLEASE DO more use cases for SETS! 👏
Thank you Cesar! Glad you found it useful. And yes, I am planning to have more use-case based tutorials on groups, sets as well as LODs, table calcs and basic calculations 🙂
Your videos are simply fantastic! The content was both informative and engaging, and your passion for the subject matter really shone through. I'm so grateful to have had the opportunity to watch it. Thankyou!❤❤❤
Thank you so much for the kind note, I appreciate it!
Sqlbelle is my all time favorite channel to learn more in depth of Tableau.
this lady is brilliant!
Thank you Russell!
Very nice explanation on Groups and Sets. Its very clear and easy way to understand. Thanks to you much Belle.
Thank you Farzana!
Very nice, you explained the difference in very simple way ,Great
WOW ma'am, love your teaching style.. worth to watch this video.. Thank you.
Thank you @siddhantghadage2439
So interesting in simple words thank you for the wonderful video
I have seen lot of your tableau video. Yes, Its really better than paid video courses.. Thanks for your wonderful teaching. I don't know how to thank you.. I never skip any Ads from your video only for you.
Thank you so much Nagarajan, that's really kind of you. I am happy you're finding the videos useful. Thank you for your kind note and gesture, much appreciated.
Yesterday I was looking for exactly this video and this morning I saw the upload. Perfect timing haha
I hope you found it useful, Simon! 🙂
you give me "Professor McGonagall" kinda vibes.... transfiguring data into insights💯
Commenting for reach. Very nice explaination.
Thank you so much Krishna!
Thanks so much for creating these videos, you are far better than those selling their courses. I can say I wasted my money on Udemy
I am glad you are finding the videos helpful, Ahabwe! Happy New Year!
So detailed yet easily explained. Love your videos.
Every video I watch from your channel seems like I have a lot to learn.... Thank you so much for making such great videos.
This video has certainly improved my understanding about Sets & Groups.. Thank you !!
I am so happy you found it helpful Rajesh!
All doubts are cleared. Great channel for learning Tableau
Thank you Sampath!
You are just simply Amazing....The way explain every l'll thing it was just awesome... Way of detailing each bite is engaging us more n more...Looking forward many more informative videos....Thank you so much...❤❤
this a great find! happy to know i have a kabayan who does this 😊
Hello Prince! Salamat :) I hope you found the video helpful and salamat sa comment at suporta!
Nice done! This worth more views!
Thank you Shisui! I appreciate that :) (and I hope so too!)
Very nicely explained the difference between sets and groups, clear and informative . Thanks a lot
Thank you Pooja! Thank you for this comment, and happy to hear you are finding it helpful! :)
Wow such a wonderful session . Loved the way you explained things. Very clear!! Please make more videos on other BI tools as well.
Thank you Sujana!
amazing job explaining groups/sets and showing examples....valuable content! great job and please keep making videos tableau related.. thank you
Thank you Ben! Glad to hear you found it helpful :)
Great lesson thanks. Love the way you teach how to handle a task in different ways.👍
Thank you :)
Wonderfully explained.. Thanks 🙂
Thank you Revanth
Nice explanation ❤️ as always ,sometime words are less to appreciate your teaching !!
Thank you, as always, Peter!
No one ever explains sets this clear...
Thank you Sakshi!
Excellent content with clear details. Thank you once again .😊
Thank you Ambuj!
Thank you ma'am..it was so well explained
Thank you Neha!
Gosh i love this channel so much!!! thank you for making these videos.
Thank you PMZ 🙂
As always, the difference between sets and groups is very well explained. Waiting for a video on Actions using Sets.
Thank you Usha, I hope you found it useful!
Your videos are Incredible!!!!
Another stunning lesson. Keep up the great work. 🤓
Thank you Guiliko!
Clearly explained!! Loved it !
Thank you Udaya!
wow, great explanation. Worth watching it.
Thank you Sabeena. Glad to hear you found the video worth watching.
Very helpful as always, thank you very much!
Thank you Sara! I am glad you found it helpful 🙂
Thanks for this video.
I learnt few new topics in Groups and Sets:
Additional options to create groups and sets
Include 'Other' option in Groups
Set Use Case 2: Proportional Brushing
Your videos are very informative!!!
amazing tutorial, thank you
Thank you Michal :)
Great video. Very well explained!
Thank you Adriana :)
Great explanation. Thank you!
You are welcome srem1971, I hope you found that helpful!
beautifully explained
Thank you Sameera!
Great work! Loved it❤️
Thank you so much Gagandeep! Happy to hear it was helpful :)
Your videos are by far the best. If possible, can you also show how to prepare a 3-way venn diagram
Wow...great work 👌
Thank you for this perfect video
Thank you Anagha!
As always,nice explanation.:)
Thank you Rajashekar!
Sure, very very useful 🎉
VERY USEFULL , THANKS FOR THE VIDEO
Thank you Sree!
Thank you - i Like way of your teac ing. understandable
Great video ...
Thank you Balvinder!
I haven't completed the video but the introduction catch my attention well done @sqlbelle🙅
Excellent, thank you 🌺🦋🌼
Thank you Alicia! Hope you found it useful!
One more question Donabel, can we have proportional brushing for two variables? I created sets for State and Region (in two different worksheets)and in the dashboard, I want Sales to be highlighted for the region/state that I select. I am observing that only one set action works at at time. Please clarify.
Love it and thank you! also love your @ :)
Thank you Isabelle! Here's to all the "belle"s :) (it's my nickname as well!)
It's so good easy and understanding ♥️ thanks for sharing 🙂 and please do a video on set actions and parameter actions..
Thank you, will do!
Thank you so much.......its just wonderfull..... thanks for explaining so beautifully :)
Thank you Tanvee! I hope you found the video useful!
@@sqlbelle absolutely......... Useful
wow, as in wow... Thank you sqlbelle :)
Thanks!
Thank you so much Srinivasa!
Wow, Awesome Explanation, Thanks a lot ,please provide Parameter topic also thanks.
Thank you Sudha 🙂
Hi Donabel, to-the-point and wonderful explanation of Sets. thanks you for this video. I didn't find part 2- additional use cases of sets. is it included in the playlist?
Thank you, as always, for your kind comments and support Pooja! I am playing catch up on creating the video tutorials. Hoping to have more soon.
HI! is ther a way to make a group with a dimmentions with values (which will be included afterwards). For example I want to add pen to the subcategery which is not included in subcategery at present. It will be added in the future. Is it possible??
Thank you for this video! It was really helpful!
Do you have video on creating sets using by formula conditions? Thanks!
Not yet, thank you for the suggestion! That's a topic that I'd like to expand on.
👌👌👌👌👌👌, keep going on
Thank you Venkat!
Could anyone explain at 20:40 what actually the bar graph is about and why the combined set is in filter
Thank you @sqlbelle !!!c
Thank you Neel!
super madam
Thank you Hari!
can you please make video on index and its uses,please
Thanks Sabin! Do you mean indexes in relational databases?
IS there a way to use the groups or sets and parameters or create diferent dimensions off main ones?
Thank you Rebekah. Would you be able to give an example of what you're thinking to accomplish?
@@sqlbelle hi sqlbelle! I think it's cute we share the same belle nickname lol! I mean I have a dimensión with 50 items and I want to instead have 5 dimensiones with 10 items to play with, it's that posible with sets? Do you give private lessons on zoom? Cause I could really benefit off one now! 😀😅
When you show top product by region (22:13), that means the top products are different for each region since the top-set is defined dynamically. Do I understand this correctly?
Hi! For the example I gave, it is the top 10 products universally, and how much of those top 10 make up the region profit. For this case, we are not looking at the "relative top 10" but the global top 10.
It's like, if our top product was "Book", it's looking at how much "Book" accounts for the region profits (how much of Central's profit is book, how much of West's profit is book, etc).
I hope I didn't confuse you.
@@sqlbelle thanks for the explanation. Excellent video! Btw, is there a way to show top 10 products for each region (locally rank instead of global ranking)?
Thank you for the useful video! I have one question about groups: I have big list of serial numbers (lets say 900 serial numbers) which I want to divide in 3 groups. I have a list which serial number in which group should be included (each group should have 300 SNs). Can I insert somewhere this list and say "This list of 300 SNs should be group 1", instead of clicking one by one and selecting every single serial number. Contains, Starts with and Exact match won't work, because there is no specific logic which serial number is which group should be. I just want to insert the list of 300 serial numbers and say this list is group 1, then insert the list of the other 300 SNs and say this is group 2 and the same for group 3..? Can I easily do that? Thank you :))
Hi! Hmm that's interesting use case. What I would probably suggest is using a different data source. I gave this a try and it seems to work ok.
I added a whole bunch of product names into an Excel file (pretending that's group 1), and copied/pasted to Tableau. It will be in a clipboard data source.
From here you can drag your original serial number and your serial number from the clipboard. You can sort based on blank serial numbers from clipboard (which means they are not in group 1), or shift-select the ones with valid corresponding values and group.
Not sure if it will work for your case but might be worth a try.
@@sqlbelle Thank you very much, will give it a try! :))
Hey, can you show how you create end-to-end dashboard from scratch? I am interested in Sales/Retail/Profit and Loss/Prior Year vs Current Year type Dashboards. Thank you!
Thank you Nishi. I have 3 videos on dashboards in general. You may be able to use those strategies with what you need for your own dashboards. th-cam.com/video/cGa7QDeueTA/w-d-xo.html
@@sqlbelle thank you so much, this is exactly what I was looking for. I really like your style of teaching. Perfect pace and great content! 👌👌👌👌👌
@@ni12907 That's great to hear.
I created two groups in group 1 I made first class ans second class
In group 2 I made third class amd fourth class lije this I made Two groups with the name of group 1 amd group 2
Now in this group 1 I have the first class this should come in to my group 2 as well
Can we do this plz help me in groups is it possible ?
Can we combine a static set and dynamic set
Hi AJ - yes we can
@@sqlbelle Thank you
Great work!
But just a quick question: sets are dynamic.
So when you drop region into the rows shelf, does region affect the top 10 products set?
That is, is it now a top 10 products per region or still the same top 10 for all regions combined?
Can u help me plz of my comment
Amazing explanation, thank you !
Thank you Ham!