Tableau Groups vs Sets - Comparison and examples (proportional brushing, top and bottom values)
Ғылым және технология
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
Пікірлер: 150
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! 😊👍
@sqlbelle
3 жыл бұрын
Thank you Vijay!
Recommended for all Tableau developers. Very clear and thorough coverage of these important topics. Thank you again for sharing your insights.
@sqlbelle
3 жыл бұрын
Thank you so much Derek! Your feedback and comments are much appreciated! 🙂
WOW! Almost two years using Tableau and just now realize what SETS can do 🤯 PLEASE DO more use cases for SETS! 👏
@sqlbelle
3 жыл бұрын
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 🙂
I just passed the Tableau Desktop Specialist certification Exam...and i owe you big time... Thank you :)
@sqlbelle
2 жыл бұрын
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.
So glad to have found your channel and see Filipina-canadian representation in the space. I loved reading your website and blogs.
@sqlbelle
3 ай бұрын
Thank you so much Micha! I appreciate your kind words and support ❤️
Sqlbelle is my all time favorite channel to learn more in depth of Tableau.
How gracefully you have explained minute details in simplest way ! More power to you. Thanks for such an incredible insights.
@sqlbelle
3 жыл бұрын
Thank you so much Gaurav! :)
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!!!
So detailed yet easily explained. Love your videos.
Really nice video... Whenever I find any difficulty in tableau, i search for your video first... :)☺️
@sqlbelle
3 жыл бұрын
Thank you so much for sharing, Piyush! So happy to hear you are finding the channel helpful :)
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 !!
@sqlbelle
3 жыл бұрын
I am so happy you found it helpful Rajesh!
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
@sqlbelle
2 жыл бұрын
I am glad you are finding the videos helpful, Ahabwe! Happy New Year!
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!❤❤❤
@sqlbelle
Жыл бұрын
Thank you so much for the kind note, I appreciate it!
No one ever explains sets this clear...
@sqlbelle
2 жыл бұрын
Thank you Sakshi!
this lady is brilliant!
@sqlbelle
Жыл бұрын
Thank you Russell!
Yesterday I was looking for exactly this video and this morning I saw the upload. Perfect timing haha
@sqlbelle
3 жыл бұрын
I hope you found it useful, Simon! 🙂
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.
@sqlbelle
3 жыл бұрын
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.
WOW ma'am, love your teaching style.. worth to watch this video.. Thank you.
@sqlbelle
Жыл бұрын
Thank you @siddhantghadage2439
Very nice, you explained the difference in very simple way ,Great
Very nice explanation on Groups and Sets. Its very clear and easy way to understand. Thanks to you much Belle.
@sqlbelle
2 жыл бұрын
Thank you Farzana!
So interesting in simple words thank you for the wonderful video
Great lesson thanks. Love the way you teach how to handle a task in different ways.👍
@sqlbelle
2 жыл бұрын
Thank you :)
All doubts are cleared. Great channel for learning Tableau
@sqlbelle
2 жыл бұрын
Thank you Sampath!
amazing job explaining groups/sets and showing examples....valuable content! great job and please keep making videos tableau related.. thank you
@sqlbelle
3 жыл бұрын
Thank you Ben! Glad to hear you found it helpful :)
Very nicely explained the difference between sets and groups, clear and informative . Thanks a lot
@sqlbelle
3 жыл бұрын
Thank you Pooja! Thank you for this comment, and happy to hear you are finding it helpful! :)
Gosh i love this channel so much!!! thank you for making these videos.
@sqlbelle
3 жыл бұрын
Thank you PMZ 🙂
Nice explanation ❤️ as always ,sometime words are less to appreciate your teaching !!
@sqlbelle
3 жыл бұрын
Thank you, as always, Peter!
Clearly explained!! Loved it !
@sqlbelle
3 жыл бұрын
Thank you Udaya!
Excellent content with clear details. Thank you once again .😊
@sqlbelle
2 жыл бұрын
Thank you Ambuj!
Your videos are Incredible!!!!
amazing tutorial, thank you
@sqlbelle
2 жыл бұрын
Thank you Michal :)
you give me "Professor McGonagall" kinda vibes.... transfiguring data into insights💯
Great work! Loved it❤️
@sqlbelle
3 жыл бұрын
Thank you so much Gagandeep! Happy to hear it was helpful :)
Thank you ma'am..it was so well explained
@sqlbelle
3 жыл бұрын
Thank you Neha!
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...❤❤
Wow such a wonderful session . Loved the way you explained things. Very clear!! Please make more videos on other BI tools as well.
@sqlbelle
2 жыл бұрын
Thank you Sujana!
Great explanation. Thank you!
@sqlbelle
3 жыл бұрын
You are welcome srem1971, I hope you found that helpful!
Wonderfully explained.. Thanks 🙂
@sqlbelle
2 жыл бұрын
Thank you Revanth
Very helpful as always, thank you very much!
@sqlbelle
3 жыл бұрын
Thank you Sara! I am glad you found it helpful 🙂
this a great find! happy to know i have a kabayan who does this 😊
@sqlbelle
2 жыл бұрын
Hello Prince! Salamat :) I hope you found the video helpful and salamat sa comment at suporta!
beautifully explained
@sqlbelle
2 жыл бұрын
Thank you Sameera!
Commenting for reach. Very nice explaination.
@sqlbelle
Жыл бұрын
Thank you so much Krishna!
Nice done! This worth more views!
@sqlbelle
3 жыл бұрын
Thank you Shisui! I appreciate that :) (and I hope so too!)
Sure, very very useful 🎉
As always, the difference between sets and groups is very well explained. Waiting for a video on Actions using Sets.
@sqlbelle
3 жыл бұрын
Thank you Usha, I hope you found it useful!
Another stunning lesson. Keep up the great work. 🤓
@sqlbelle
2 жыл бұрын
Thank you Guiliko!
Great video. Very well explained!
@sqlbelle
2 жыл бұрын
Thank you Adriana :)
wow, great explanation. Worth watching it.
@sqlbelle
2 жыл бұрын
Thank you Sabeena. Glad to hear you found the video worth watching.
Wow...great work 👌 Thank you for this perfect video
@sqlbelle
2 жыл бұрын
Thank you Anagha!
Your videos are by far the best. If possible, can you also show how to prepare a 3-way venn diagram
Thank you - i Like way of your teac ing. understandable
Great video ...
@sqlbelle
2 жыл бұрын
Thank you Balvinder!
Excellent, thank you 🌺🦋🌼
@sqlbelle
3 жыл бұрын
Thank you Alicia! Hope you found it useful!
VERY USEFULL , THANKS FOR THE VIDEO
@sqlbelle
2 жыл бұрын
Thank you Sree!
Thanks!
@sqlbelle
2 жыл бұрын
Thank you so much Srinivasa!
As always,nice explanation.:)
@sqlbelle
3 жыл бұрын
Thank you Rajashekar!
wow, as in wow... Thank you sqlbelle :)
Thank you so much.......its just wonderfull..... thanks for explaining so beautifully :)
@sqlbelle
3 жыл бұрын
Thank you Tanvee! I hope you found the video useful!
@teenuptanvee
3 жыл бұрын
@@sqlbelle absolutely......... 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.
It's so good easy and understanding ♥️ thanks for sharing 🙂 and please do a video on set actions and parameter actions..
@sqlbelle
2 жыл бұрын
Thank you, will do!
Love it and thank you! also love your @ :)
@sqlbelle
3 жыл бұрын
Thank you Isabelle! Here's to all the "belle"s :) (it's my nickname as well!)
Wow, Awesome Explanation, Thanks a lot ,please provide Parameter topic also thanks.
@sqlbelle
3 жыл бұрын
Thank you Sudha 🙂
Thank you @sqlbelle !!!c
@sqlbelle
2 жыл бұрын
Thank you Neel!
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?
@sqlbelle
3 жыл бұрын
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.
👌👌👌👌👌👌, keep going on
@sqlbelle
3 жыл бұрын
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 for this video! It was really helpful! Do you have video on creating sets using by formula conditions? Thanks!
@sqlbelle
2 ай бұрын
Not yet, thank you for the suggestion! That's a topic that I'd like to expand on.
super madam
@sqlbelle
2 жыл бұрын
Thank you Hari!
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??
IS there a way to use the groups or sets and parameters or create diferent dimensions off main ones?
@sqlbelle
2 жыл бұрын
Thank you Rebekah. Would you be able to give an example of what you're thinking to accomplish?
@rebekahalvarez8627
2 жыл бұрын
@@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?
@sqlbelle
3 жыл бұрын
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.
@cocoon757
3 жыл бұрын
@@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 :))
@sqlbelle
2 жыл бұрын
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.
@meshell7987
2 жыл бұрын
@@sqlbelle Thank you very much, will give it a try! :))
can you please make video on index and its uses,please
@sqlbelle
3 жыл бұрын
Thanks Sabin! Do you mean indexes in relational databases?
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!
@sqlbelle
3 жыл бұрын
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. kzread.info/dash/bejne/lXuVmbN9ldjLhKQ.html
@ni12907
3 жыл бұрын
@@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! 👌👌👌👌👌
@sqlbelle
3 жыл бұрын
@@ni12907 That's great to hear.
Can we combine a static set and dynamic set
@sqlbelle
2 жыл бұрын
Hi AJ - yes we can
@AJ-bd8os
2 жыл бұрын
@@sqlbelle Thank you
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 ?
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
I haven't completed the video but the introduction catch my attention well done @sqlbelle🙅
Amazing explanation, thank you !
@sqlbelle
2 жыл бұрын
Thank you Ham!