Drill Down using Set Actions in Tableau
Вставка
- Опубліковано 25 чер 2020
- Tutorial about how to use set actions in tableau to drill down individual category.
Link to tableau dashboard: public.tableau.com/views/Howt...
--------------------------------------------
📚 Recommended Books
--------------------------------------------
📚 DATA VISUALISATION & STORYTELLING
Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
The Big Book of Dashboards amzn.to/3q4i3eG
Data Visualization: A Practical Introduction amzn.to/44KYrel
Storytelling with Data : Lets Practice amzn.to/44O7WcL
Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
📚 SQL
SQL for Data Analytics: amzn.to/3rROkGj
SQL 3 books in 1 : amzn.to/3KklUuY
Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
SQL Quick Start Guide: amzn.to/3KInOpx
📚 DATA ENGINEERING
Data Engineering with Python : amzn.to/3YelH1Y
Data Engineering with AWS: amzn.to/3YgXoAL
Fundamentals of Data Engineering: amzn.to/3OAUVxy
Software Architecture: amzn.to/3KmNffX
System Design Interview: amzn.to/3Yhfy5q
Ace Data Science Interview: amzn.to/3rOxcBl
System Design Interview: amzn.to/3OAw8d7
Designing Machine Learning Systems: amzn.to/3YbGxiB
📚 SOFTWARE ENGINEERING
Clean Code amzn.to/47aBnr4
Clean Architecture amzn.to/3OA8VaP
The Programmatic Programmer: amzn.to/4793k2C
-----------------------------------------
👇 CHECK THIS OUT! 👇
-----------------------------------------
🏪 AMAZON STOREFRONT
www.amazon.com/shop/datavizca...
All my recommendations for books, gadgets and gear are also available at my
Amazon storefront. Check it out!
👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
You can purchase one here: www.datavizcanvas.com/shop/#!/
--------------------------------------------------------------------------------
😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
--------------------------------------------------------------------------------
Instagram: / datavizcanvas
Twitter: / datavizcanvas
Facebook profile.php?...
Linkedin: / gurpreetsingh515
Tableau public public.tableau.com/app/profil...
Website : www.datavizcanvas.com/
-------------------
GEAR I USE
-------------------
📷 Video
Canon EOS RP amzn.to/3QkOpfU
Canon RF 35mm amzn.to/3rNIh5E
Canon RF 14-35mm amzn.to/44JQw0Y
🎙️ Audio
Rode NT-USB Versatile Studio amzn.to/3DCbxyY
Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
⏱ TIMESTAMPS
‼️ DISCLAIMERS
Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!
Thanks for being a part of this channel and all your support! 💪 🙏
this was an excellent video! thank you and just subscribed to your channel!
Thanks Dan for your feedback and for supporting my channel 🙂. Stay tuned for more such videos.
Cheers!
Nice one sir, I could do it before watching the entire video because of the well explained videos you made earlier on set & actions.
That’s great. Glad you are enjoying it. Keep up the good work and share it with community 👍
Indeed an excellent video
Thanks Harish. Stay tuned for more such videos and thanks for supporting my channel. Cheers!
Gurpreet
Amazing!
Thanks 🙏🏽 Wendy
Great! how can I add totals when I do the split? I need to show the total of the category and the detail. Thank you!
Nice and very useful one; but is that possible (in this case) Sub category should not open in separate column but underneath of Category with some indentation ? Thanks
How to do like this +Category
Books
Mobiles
Music
under this I should get all the sub cat values like above mentioned so can u help me on that
Thank you for the demo, how can we expand two categories at the same time?
Hi Antonio,
You can do the same way by creating multiple calculation and same logic.
Please try that and let me know in case of any issues.
Cheers!
Hi , impressed,
I need multiple 4 layer dill down and drop down as you had just one level, how can we do accomplish that. Kindly help
Thank you.
Hi Thats a great question.
You can do it the same way by creating multiple calculations and multiple sets for individual layer. Please try and let me know incase of any issues.
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
Nice work!
I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go.
Cheers!
Gurpreet
Nice work!
I haven't tried adding totals using multi level drill down but logically if you use windows calculation then it will add the total for that section. Please try that and let me know if it still doesnt work then i will give it a go.
Cheers!
Gurpreet
What about sub categories leading to let's say product.. how do we get that
Hi Piyush, that a great question.
If you need 3 levels of drill down then you need to create a similar calculation for third layer
if [set1] and [set2] then [Product]
else ' '
end
Hope that helps:-)
Little tricky to do but got it working
@@LokeshS-nz4ti great work :-) Please do share your work with Tableau community as well. Cheers!
@@LokeshS-nz4ti Hi lokesh, I am unable to drill it to the third level. Could you please help me with this?
How to proceed further to drilldown por let say product after subcategories? Please give me some explanation?
Hi Ajinkya, you can create as many layers of drill down you want using same technique. you just need to create more calculations the ways you used it for first layer of drill down. Please try that and let me know if you need any help. Cheers!
Thanks for uploading, its nice video. May i know how to achieve this in 2020.2 version.
Hi Nama, It will work the same way in Tableau 2020.2 as well. You can download this dashboard from the link in description of this video and try it on tableau 2020.2