Tableau Group vs Set [What's the Difference between Tableau's Sets and Groups?]

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024
  • Download our Top 10 Dashboard Tips for Free:
    This video will explain the differences between Tableau Groups and Sets. They are both very similar and so examples of both will be shown in Tableau. Tableau groups are a simpler version of a Tableau set. A Tableau group is one dimensional while Tableau sets can have conditions and can be grouped across multiple dimensions. In this video, we will create a region by grouping states and will show examples of a constant set, dynamic set and how to join two sets to make a combined set.
    ---------------------------------------------
    ABOUT VIZUAL INTELLIGENCE INC.
    Vizual Intelligence Inc. is an Innovative, Creative and Effective Tableau Consulting & Training Company led by a young entrepreneur with a goal to use his expertise with Tableau to revolutionize your business intelligence.
    Tableau Consulting: vizual.consulti...
    Tableau Training: vizual.consulti...
    Tableau Survey Analytics: vizual.consulti...
    Our blog: vizual.consulti...
    Tyler Lubben, MBA vizual.consulti...
    #tableau #tableautraining #tableaututorial #tableautiptuesday

ความคิดเห็น • 93

  • @jamieantonino8011
    @jamieantonino8011 6 ปีที่แล้ว +8

    Great & very helpful video! I noticed there is a mistake during the last example you may want to clear up: the wrong set is dropped in at 12:00 instead of the recently created combined set which leads to the wrong variables being mapped in the visualization. I thought I was going crazy!

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว +1

      Thanks! Glad it helped. I noticed that but TH-cam wont let me change the video, I have to deleted it and just start from scratch. I may just have to do that :/

    • @danielstober6249
      @danielstober6249 5 ปีที่แล้ว +1

      Good catch, I was just going to comment and ask why appliances have “out” when both of the other two are “in”. (At 12:04). Initially I was even more confused because he dropped the third set in between the other two - which I only noticed by running it back a couple times. Overall good video, but I wish he would have lingered after adding the combined set and he would have noticed the inconsistencies

  • @TheDistractionStudio
    @TheDistractionStudio 5 ปีที่แล้ว +3

    Commenting again after watching the whole video. Before this video I kinda knew what Groups were and knew there was something called sets but now thanks to helpful people like you, I know exactly what is what and when to use one over the other. 🙏

  • @Rajesh-nj1gm
    @Rajesh-nj1gm 6 ปีที่แล้ว +1

    I watch lot of Tableau calculation video but never I feel confident to understand that details. But it really awesome and easy to catch. Thanks.

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว +1

      Thanks man, ill be putting out alot more content starting next month.

  • @roopadamu9289
    @roopadamu9289 ปีที่แล้ว

    This is the video which helped me understand the concept. Thanks very much. Great video!

  • @pipitkiswieantoro6753
    @pipitkiswieantoro6753 6 ปีที่แล้ว +5

    Thank you for your explanation.

  • @nataliag1140
    @nataliag1140 5 ปีที่แล้ว +2

    Thank you for the video. Very well done. The only little thing that could be improved is your interpretation of the data. When you look at the discounts, profit and sale amounts you are talking about people. But you are not analyzing it by customers, you analyzing data by product sub-groups. From the building a visual point of view it is not an issue. It's just that explanation sounds strange.

  • @kuku7330
    @kuku7330 2 ปีที่แล้ว

    great video!

  • @staciejohnson9578
    @staciejohnson9578 3 ปีที่แล้ว

    That was very helpful! Please keep making these videos.

  • @Farhan198
    @Farhan198 4 ปีที่แล้ว +1

    Thank you, concepts are clear now :)

  • @yatishmalik
    @yatishmalik 3 ปีที่แล้ว

    Great explanation

  • @6toolbaseball
    @6toolbaseball 4 ปีที่แล้ว

    Best explanation I've seen yet!

  • @omelturk4609
    @omelturk4609 5 ปีที่แล้ว +4

    Good video on Groups and Sets BUT........You brought in Set = "Top Sales and Profit..." not "Profit >0 and sales >100,000" (Time 12:00-12:05). "Appliances" and "Machines" should be IN for "Profit >0 and sales >100,000".

    • @catalino5715
      @catalino5715 4 ปีที่แล้ว

      I agree, but what is wrong here?

    • @LBizKid04
      @LBizKid04 4 ปีที่แล้ว

      I thought I saw that too, good catch 👍🏻😁

  • @1999carbon
    @1999carbon 4 ปีที่แล้ว +2

    Amazing, all well explained. thank you!

  • @zubeenlapsiwala
    @zubeenlapsiwala 2 ปีที่แล้ว

    Great explanation. Thanks

  • @zachdorflinger558
    @zachdorflinger558 4 ปีที่แล้ว

    Why wasn't Appliances colored green in the final dynamic set? It looks like it is in both the Profit > 0 and Sales > 100,000 sets, but when combined it was not included. Any idea why this happened? Just curious. Thanks for the great video!

  • @jollycolours
    @jollycolours 3 ปีที่แล้ว

    thank you so much for this tutorial, it was well-explained with multiple examples, can't thank you enough :D

  • @123admini2r
    @123admini2r 4 ปีที่แล้ว

    Good video

  • @jstewart_1
    @jstewart_1 3 ปีที่แล้ว

    very nice

  • @ateeqahmad
    @ateeqahmad 5 ปีที่แล้ว

    Very cool video. The green and red choice threw me a bit because I am a little color blind

  • @mrsdancinmary
    @mrsdancinmary 3 ปีที่แล้ว

    After combining the sets, why are Applicances and Machines not IN? They have both Profit > 0 and Sales > 100,000 but are shown as OUT. Can you explain that? Great video in general though, thank you!

  • @vsagar4b38
    @vsagar4b38 4 ปีที่แล้ว

    Thanks Very Well Explained.

  • @michafabich4372
    @michafabich4372 3 ปีที่แล้ว

    well explained, thanks!

  • @Its_Lilypad_
    @Its_Lilypad_ 3 ปีที่แล้ว

    Thanks a lot! Very useful!

  • @sanketsinha8933
    @sanketsinha8933 6 ปีที่แล้ว

    Hi a great video! can you tell me why few of the dashboards are showing red and few are showing blue below?

  • @KalpadeepBhattacharjee
    @KalpadeepBhattacharjee 3 ปีที่แล้ว

    Is groups are created on dimensions and sets on measures?

  • @harshav8617
    @harshav8617 7 ปีที่แล้ว +1

    Nice Info about Groups & Sets. Here I have a small query, how we can use groups in Calculation fields?

    • @vizualIntelligence
      @vizualIntelligence  7 ปีที่แล้ว +1

      In the newer versions of Tableau you can but below you would have to create a if then statement to group it or a set.

  • @venkannabanothu9845
    @venkannabanothu9845 5 ปีที่แล้ว

    Thanks sir excellent explained and your any Tableau videos

  • @fantouch
    @fantouch 4 ปีที่แล้ว

    I have been having problems with the dynamic sets, can I made a condition in the sets with created fields?! When I tried the created fields are not available , why?

  • @KR-good
    @KR-good 6 ปีที่แล้ว +1

    Great explanation.

  • @mtro.alfonsodominguezsalci9976
    @mtro.alfonsodominguezsalci9976 7 ปีที่แล้ว +2

    Thanks!, clear and well explained

  • @Mr_MinusTwo
    @Mr_MinusTwo 4 ปีที่แล้ว

    Hey great video. I'm struggling to combine sets. When I right click on one of the two sets I've created I don't see the option to combine sets. Is there a different way to bring that option up?

  • @redwings02
    @redwings02 3 ปีที่แล้ว

    Maybe this wasn't true in 2017, but you can group across multiple dimension in Tableau now, yes?

  • @YeungLorentz
    @YeungLorentz 5 ปีที่แล้ว

    very good and detailed explanation , thank you.

  • @sushantumap601
    @sushantumap601 5 ปีที่แล้ว

    Excellent Video.. 👍🏼👍🏼

  • @anushak7113
    @anushak7113 6 ปีที่แล้ว

    Clear explanation...
    Thank you...

  • @harshadhardas1648
    @harshadhardas1648 4 ปีที่แล้ว

    Thank you, very clear.

  • @sowmyakrishnam1444
    @sowmyakrishnam1444 4 ปีที่แล้ว

    short & crisp

  • @filippoantoniocapizzi9068
    @filippoantoniocapizzi9068 5 ปีที่แล้ว

    Thank you, clear and linear.

  • @pulakverma1670
    @pulakverma1670 4 ปีที่แล้ว

    Can we combine more than 2 sets ?

  • @GurpreetSingh-cd5ir
    @GurpreetSingh-cd5ir 5 ปีที่แล้ว

    Great explanation. Quite astute with the content. Easily the best hitherto.

    • @vizualIntelligence
      @vizualIntelligence  5 ปีที่แล้ว

      Thanks, I try to make things as easy as possible

  • @SinaiShur
    @SinaiShur 6 ปีที่แล้ว +1

    Great tip! Thanks!

  • @JonathanJournal
    @JonathanJournal 4 ปีที่แล้ว

    thanks

  • @da_vinci5100
    @da_vinci5100 3 ปีที่แล้ว

    Perfect!

  • @manjeets761
    @manjeets761 5 ปีที่แล้ว

    Nicely explained. But question about Map where I was not able to view one of Zone name and rest of regions were displaying out of 4. Can you please suggest the problem

    • @vizualIntelligence
      @vizualIntelligence  5 ปีที่แล้ว

      Hey, sorry not understanding your question can you reword it please?

  • @bakmijowomasaryo9332
    @bakmijowomasaryo9332 5 ปีที่แล้ว

    Cool explenation

  • @SH-gs4fb
    @SH-gs4fb 6 ปีที่แล้ว +1

    Very good explanation thank you

  • @1234567890ivotube
    @1234567890ivotube 2 ปีที่แล้ว

    I hope somebody sees this. What's the difference then between constant sets and groups?

  • @thulilerankwemoroka2923
    @thulilerankwemoroka2923 4 ปีที่แล้ว

    What if my data source is from an sql query, it gets updated everyday and there are new items not belonging to any group? how do I make it to auto group?

    • @yourdadsmusic
      @yourdadsmusic 4 ปีที่แล้ว +1

      have you tried creating a Set based on a Condition?

  • @malerhino
    @malerhino 4 ปีที่แล้ว

    In the Combined Set Graph, there is a red datapoint that has sales >$100K and profit >$0. Shouldn't it be green?

    • @malerhino
      @malerhino 4 ปีที่แล้ว

      I watched more closely and noticed you colored the last graph by the original (manual) set and not the one you created to automate the process.

  • @crypto_peng
    @crypto_peng 5 ปีที่แล้ว

    Nice

  • @sobanali
    @sobanali 6 ปีที่แล้ว

    Great vidoe,
    How to select all the values in the column at once, like I selected the values, I apply a filter now the remaining i to group all these thousand of values in the column at once, instead of selecting one by one by clicking, is there any easy selection method? i tried CTRL+A but it didnt work, i als o tried press and hold mouse button, like you did at 4:30
    Thanks

    • @sobanali
      @sobanali 6 ปีที่แล้ว

      got it with SHIFT, thanks, kind a newby i am. lols

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว

      Yes that shift comes in handy haha

  • @kartikeyatiwari6678
    @kartikeyatiwari6678 6 ปีที่แล้ว

    Thank you soo much.. waiting for tableau penlist to take my interview.. I can give exactly same examples :) :)

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว +2

      You are very welcome, just curious whats Tableau penlist?

    • @kartikeyatiwari6678
      @kartikeyatiwari6678 6 ปีที่แล้ว

      Vizual Intelligence Inc. tableau interview pannel (evaluaters).. n thanks they asks me couple of questions on sets.. n got selected today.. :)

  • @sheetonyu
    @sheetonyu 6 ปีที่แล้ว +4

    You made a mistake in your set (profit >0 sales >100) in that you put the wrong set in your table (you put Top Sales). May want to check that out.

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว

      Thanks I appreciate that, Ill take a look at it. Good catch.

    • @smanalyst666
      @smanalyst666 5 ปีที่แล้ว

      @@vizualIntelligence Your presentation is so very well, that the error is hardly any blocker. Thanks for this helping video

    • @pete4898
      @pete4898 4 ปีที่แล้ว

      @@vizualIntelligence Did you take a look?

  • @cynthiaa3612
    @cynthiaa3612 6 ปีที่แล้ว

    Is it possible to create a dynamic set even if the dimension is not unique? I'm creating an employee productivity set where some employees float in multiple sites so they be "In" in one site, and "Out" at another site. However, I see that the set just marks both as "Out". How can I work around this?

    • @vizualIntelligence
      @vizualIntelligence  6 ปีที่แล้ว

      Can you explain a little more please?

    • @cynthiaa3612
      @cynthiaa3612 6 ปีที่แล้ว

      My dynamic set has a condition of Fill Rate>80% based on Fill Rate calculated field I created. Nicola works in two locations, say "Rural" and "City". In Rural her fill rate was 57% and in City, 85%. However my dynamic set marks both as "Out". On another occasion, Karie works in "City" and "County" and scores 12% in City and 82% in County, but is marked as "Out" in both.

    • @tlubben972
      @tlubben972 6 ปีที่แล้ว

      +Cynthia A ok I got it. Its calculating the total rate for that person not taking into account the new dimension. so what is it you want it to do? if they past one and not the other is it in? or they have to past both?

    • @cynthiaa3612
      @cynthiaa3612 6 ปีที่แล้ว

      I want to be able to show the fill rates independent of each other. So anything below 80% is OUT and above 80% is IN. Both Karie and Nicola should have one IN and one OUT. Can it do that?

    • @tlubben972
      @tlubben972 6 ปีที่แล้ว

      +Cynthia Then you need to create a measure for each of the fill rates using a if then statement then do a separate set for each measure.

  • @arunkumar2029
    @arunkumar2029 4 ปีที่แล้ว

    Why can’t we just use a calculated field saying profit > 100 and sales > 100000 and use it in color?

  • @j_boogie_483
    @j_boogie_483 5 ปีที่แล้ว +4

    "illinoise"

    • @redwings02
      @redwings02 3 ปีที่แล้ว

      He must be a Sufjan fan.

  • @adrianfletcher8963
    @adrianfletcher8963 4 ปีที่แล้ว

    7:57 and 12:27 *Red-green colorblindness has entered the chat*

  • @TheDistractionStudio
    @TheDistractionStudio 5 ปีที่แล้ว

    Paused the video midway to add a THANK YOU comment. Now going to un-pause it :)

    • @vizualIntelligence
      @vizualIntelligence  5 ปีที่แล้ว +1

      Haha thanks! Any other topics you have a hard time on, thinking of subjects for me next video now. I will be releasing a video all about Maps soon.

    • @TheDistractionStudio
      @TheDistractionStudio 5 ปีที่แล้ว

      Vizual Intelligence Inc. Yes, though I have made it work but not sure if there are alternative solutions- Issue: Have a Dashboard with 8 tabs/worksheets and the quick filter selections remain selected in each tab so that the end user can continue with their analysis. We have around 9 quick filters and sometimes the users forget to undo all the selections. Is there a easy way to RESET all the filters. I am using a url action to reset the Dashboard which is also resetting the filters.

  • @angel8299
    @angel8299 3 ปีที่แล้ว

    .

  • @laksmiles3171
    @laksmiles3171 2 ปีที่แล้ว

    Hi Friends,
    Do check out my latest video on " Differences between sets and parameters " in Tableau.
    Thanks for watching. Have a nice day 💐🎉
    th-cam.com/video/xCDDpgaj1xU/w-d-xo.html

  • @saikiran307
    @saikiran307 7 ปีที่แล้ว +1

    Great explanation

  • @feridboussoffara2377
    @feridboussoffara2377 5 ปีที่แล้ว

    Very well explained, thank you !