Drill Down with Set Actions in Tableau

แชร์
ฝัง
  • เผยแพร่เมื่อ 16 ธ.ค. 2024

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

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

    Thank You Andy. Coincidentally I have to build a POC for something that should work like exactly how you showed and I was stressing on how best to build one. You are a God Sent Gift. Thank You 🙏

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

    Thanks for the video. I am still amazed how complex this has been made in Tableau compared to Power BI for example.

    • @vizwiz
      @vizwiz  2 ปีที่แล้ว +1

      Different tools do things differently. 👍🏻 I can think of lots of things that Tableau does the PBI makes complicated.

  • @anthonyduque4320
    @anthonyduque4320 3 ปีที่แล้ว +2

    Exactly what I was looking for! Thank you! Gonna use it for an organizational chart. The other videos for org charts are toooooooo complicated. This is straight-forward and has a nice clean design. You saved me my job! B-)

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

      You are so welcome!

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

    I dropped one of my project earlier because i could not do what you just taught us. Thankyou is a small word but ya thankyou.

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

    Nice video Andy. Are you able to do a video with multi level drill down using set actions?

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

      Am looking for this exact same thing.

  • @MonikaRaghuvanshi-l8h
    @MonikaRaghuvanshi-l8h 9 หลายเดือนก่อน

    Thank you! I want to also add collapse all and expand all feature on the dashboard with this sheet. Any help is appreciated.

  • @rainbowmui1456
    @rainbowmui1456 3 ปีที่แล้ว +1

    Awesome tutorial, exactly what I am looking for!

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

    Very helpful video, thanks Andy!

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

    Hi Andy! is there a way to same way of selective drilling down for Subcategories, Manufacturers and Product in the same sheet? Appreciate your thoughts on the same.

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

      Here you go - th-cam.com/video/cj9KDO8nb8A/w-d-xo.html

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

    Hi Thank you very much. However, what if we dont want to show category and sub-category both after drill down. In this case, the visualization will be, once one category will be clicked, we will only see the sub-category for that particular category.

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

    I have a sheet in the dashboard, where all the state locations are grouped in APAC, AMER, EMEA. Now the user wants to export a file/excel from that sheet which will have all the states belong to which region. Can somebody please help?

  • @Mohammad-rz7oj
    @Mohammad-rz7oj 3 ปีที่แล้ว

    Hi Andy, i have a requirement for which i am counting a sequence basing on category in bar chart, so when i click on a particular bar , it has to split basing on the date. for example if i have a bar with the count of 20 and when i click on the bar, it has to split by the date and has to show all those 20 sequence along with the dates.

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

    I tried to implement this one step further (basically then click on the subcategory and then the next set opens for the specific category - subcategory selection but that did not work. Is it possible to drill down further then only one time? Thanks

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

    Thank you so much!! This was incredibly helpful. Does anyone know how I can change the category rows and manipulate what they're adding together? I don't want to delete any subcategory rows, but I would like to exclude some from the SUM calculation for the main category. Or, if I can make it so that the main categories are not doing a SUM at all when not selected, and it only shows values when you drill down, then that would work too. Thanks!

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

    thank you for the video, how can we expand two categories at the same time?

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

      When setting up the action, make sure you don't pick the option that limits it to a single select. Then when you pick multiple items at the same time, they'll both expand.

  • @jason.hansen
    @jason.hansen 5 ปีที่แล้ว +1

    Hi. I have followed the instructions and created worksheets with the actions, but when I put those sheets inside of a dashboard the functionality is lost?

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

      Jason Hansen yes. Towards the end of the video I mentioned how you have to set them up again in the dashboard.

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

      @@vizwiz Hi Andy Kriebel. the Video was very interesting. I am also struck in the last step where it works in the sheet but not in the dashboard. can you please let me know is there is a workaround? Unfortunately I do not see any solution for this in the end of your video. thanks.

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

      Naveen Doss Maria Dosss read the comment above

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

      @@vizwiz you do not mention the dashboard portion

    • @xidanxu5871
      @xidanxu5871 5 หลายเดือนก่อน

      @@kmot92 ​ @naveendoss I figured this problem (dashboard does not work with the created worksheet/table's select function)
      - After you add the worksheet to a dashboard, add a new Action to "This Sheet". The action previously created is only in "This Workbook". If you create and add the same action in "This sheet", this table/worksheet should work like expected in the dashboard.

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

    Hi Andy, any idea as to why when I add on the third level it doesn't expand like it's supposed to. For example, when I select categories, everything opens not just the category I selected. thanks for any help

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

      I learned from this example by Lindsey Poulter. Have a look at her calcs. public.tableau.com/profile/lindsey.poulter8872#!/vizhome/SetActionDrilldown/ScatterPlotDrilldown

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

    Hey Andy, this is useful. Can I get Rank function on top of the categories? As I want dynamic selection of categories using a parameter.

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

      I don’t understand your question, sorry.

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

      @@vizwiz sorry, can I rank my categories? Then use a parameter to get top 5 or top 10 categories based on rank.

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

    Hi, Thank you for your content.
    Is there an other way to do that without the Change Set value? I am not able to update the version of Tableau to enable the set actions.

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

    Haver you ever run into an error message in the 'Add Set Action' menu 'Missing field on drilldown'? I tried to continue another level and can't get past that error.

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

      Yes. That means that the field that triggers the action is not on the sheet. It would be the field the set is based on.

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

      @@vizwiz Would it not be in the view once it is populated into the set from the previous action? I'm also using measure names and measure values and am unsure where I would put the field the set is based on. Placing it on rows would populate the members which I want populated by the drilldown and placing it somewhere like detail effects the values.

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

      No. The field that set is based on must be in the view if you are going to run an action upon it.

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

    Hello Andy, I have extended this technique also for the columns, adding the months. Is there a way to add the totals per years in the view with the months without add all the sub totals?

    • @vizwiz
      @vizwiz  3 ปีที่แล้ว +1

      I believe there are two Workout Wednesdays that might be what you are after...
      Challenge 2019 Week 35
      1. Requirements - www.workout-wednesday.com/week-35-drill-down-up-on-sales-with-subtotals-using-parameter-actions/
      2. My Solution - public.tableau.com/profile/andy.kriebel#!/vizhome/WorkoutWednesday2019Week35-DrillDownandUponSaleswithSubtotalsusingParameterActions/WW2019W35
      Challenge 2019 Week 1
      1. Requirements - www.workout-wednesday.com/2019-week-1/
      2. My solution - public.tableau.com/profile/andy.kriebel#!/vizhome/WorkoutWednesday2019Week1-SalesDrill-Down/WWWeek1

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

    Hey Andie, Thank you for wonderful tutorial. But, I'm stuck at creating the action on the set. It gives a warning message saying ""missing fields on sheet"" when I select the target set. And later on when I click on category, it doesn't work.

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

      That means the sheet that you are setting the action to apply to doesn’t have the field the set refers to on the view somewhere.

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

    Thanks for the video, How did you tack on those symbols to Category, can you pls tell the shortcut.

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

      I show in the video.

  • @hello-u2w
    @hello-u2w 3 ปีที่แล้ว

    when you have more than 2 categories, how do you accommodate for that?

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

      This will work with two categories as long as you allow your set action to run on more than one selection.

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

    Many thanks! Just updated version of Tableau to enable set actions.

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

    Great video! Is there a way to count the number of customers responsible for 80% of sales in a calculated field that updates based on filters? For example, a worksheet title that would say "XX customers are responsible for 80% of sales in East Region in Furniture Category". Is that possible?

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

    Hi Andy - great video.. is it possible to have a 3rd column after Sub Categories named Product and with Subcategories showing the same side/down arrow.. so basically Categories can be expanded to Sub Categories like you showed in the video - is it then possible to have Sub Categories (one Sub Category at a time) to be expanded to Products lets say.. I tried it using 4 columns in total named Business Unit, Region, Country and Location.. when I expand Business Unit then only Regions should appear with Down Arrow signs but it expands all columns i.e. Region and Country showing the Location per Market..is there any tip/trick to apply the logic you have shared in your video to more columns :)

    • @vizwiz
      @vizwiz  3 ปีที่แล้ว +1

      Yes, there's a viz on Lindsey Poulter's Tableau Public page in which she shows the technique. Keep in mind, that while it's super useful for the user, it's super complicated to implement.

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

    Awesome use of set actions.

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

    Great Tutorial, but this does not seem to work if I want multi-level Drill Down, since the second set is seleceted by the first set, it shows all values in the third set.
    Example:
    I have City -> Zone -> Group
    When I create a city set, and zones are selected depending on this set, I create a set from the zones selected, and depending on the zones selected set I show groups, all the zones selected are selected from the city set so it shows them all but I want to show them only when a zone is clicked

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

      How about this? Tableau Guide: 3 Level Bar Chart Drill Down
      th-cam.com/video/cj9KDO8nb8A/w-d-xo.html

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

    As always, Brilliant Andy

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

    Hi Andy, this is awesome!
    Is there a way to set it up so that one can drill down more than 1 level, I have a requirement to setup a 5 level drill down, and wanted it done using set actions. Any help would be great! :)

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

      There’s a viz by Lindsey Poulter on Tableau Public that shows how to do it.

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

      @@vizwiz Thank You Andy for your reply :) Hope you have an amazing day!

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

    I am trying to recreate this example. When I added YEAR to the columns it stops selecting. I remove it then it works again. I am using 2021.4. Anyone has the same experience?

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

      Double check the steps. If that’s what I did, then it will work if you follow the steps exactly.

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

    thank you for the content. it is useful. I have another question, is there a way to further drill down the subcategories?

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

      Yes, absolutely. Check out Lindsey Poulter's examples.

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

      @@vizwiz where we can get this

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

      @@Manikandanbalan the link is in the video description

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

      @@vizwiz This was super helpful! Now I am also trying to further drill down, but I can't seem to find Lindsey's examples.

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

      @@emilykunstler1467 Here you go - public.tableau.com/profile/lindsey.poulter8872#!/

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

    Hi Andy, thank you for sharing this. Been googling too long to do this kind of action in Tableau.
    btw, is there any workaround on the sorting so that it won't automatically go to the bottom? or its really just manual sorting one by one?

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

      If you mean the category sorts to the bottom, then what you need to do is duplicate the Category field in the Data pane. Move that to the rows as the first field, then sort that field. I think that'll do it. Though it may add the option you click on to every row.

  • @user-re5uv2mm2h
    @user-re5uv2mm2h 3 ปีที่แล้ว +1

    Great help! Subscribed!

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

      Awesome, thank you!

  • @MrStark-zy6cd
    @MrStark-zy6cd 5 ปีที่แล้ว

    Looooooved it!!! Thank you very much!!!!

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

    Just genious!!

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

    Good Tip

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

    Nice!!!