How to in Tableau in 5 mins: Create a Set Action Drill Down

Learn how to Create a Set Action Drill Down with Lukas Jennings
----------------------------------------------------------------------------------------------------
Want more information about us? Head over to theinformationlab.co.uk
Want to see more of our events? Head over to til.bi/talkdata to find out more
----------------------------------------------------------------------------------------------------

[@o__v__i__2]

This was life saving!!! THANK YOU 😊

[@theinformationlab]

Glad it helped!

[@cocoon757]

This is very helpful! thank you, please make more!

[@gonzaloherediaedelstein7631]

Very useful. Thanks a lot.

[@gonzaloherediaedelstein7631]

Tried to do this with numerical bins (trying to drill down from 365 size bins to 30 size bins). The IF operator doesn't work with these types of categories. Any thoughts? Thanks in advance

[@theinformationlab]

Hi Gonzalo - asking my colleagues for ideas for you!

[@claudiasorvillo9377]

Thank you!

[@theinformationlab]

You're welcome!

[@arayabehera8008]

Thanks for this useful video.I tried the same thing and able to do 4th level drill down as well but i stucked when doing totals and subtotals because this is showing outside the hierarchy actually that totals and subtotals should be shown while we do drill down but it is present as static field do you have any solution on this it will be helpful for me

[@FayazKhan-im5fh]

If I click on furniture and want to see it's sub categories but don't want to see the other 2 category what to do

[@paulinaromanczuk9515]

Hey, did you find an answer to that?

[@chloelu4390]

Thanks! It Works ver well in work sheet and dashboard, but not in story navigation point, is it natural limitation in Tableau…?

[@theinformationlab]

Hi Chloe, thanks for your question. We've had a check internally and we think that using the set actions with story points might cause an issue with how story points fundamentally work, which means it might be a no. However, you can ask on the Tableau Community for a surefire answer from the developers!

[@kvsider7599]

I'm trying to do a line chart with a single Sum Total Sales line over time. When the single line is clicked then three lines of subcategories would show instead (total sales over time for Furniture, Tech & Office Supplies) Would this be possible?

[@jlantigu]

hi!, why does it work on the sheet page without problem but when I take it to the dashboard it doesn't perform the drill down ?!?! =(