Top N & Bottom N vs Others in Tableau
How to show top N values, bottom N values, top N & bottom N values combined and to show top N vs other values , bottom N vs other values in Tableau.
--------------------------------------------
📚 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
Thanks for being a part of this channel and all your support! 💪 🙏
⏱ TIMESTAMPS
00:00 - Introduction
02:49 - How to show Top N values
06:26 - How to show BottomN Values
07:29 - How to show Top N & Bottom N values combined in tableau
08:57 - How to show Top N vs Other in the form of Bar Chart
12:16 - How to show TopN vs Other in the form of pie chart
‼️ 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!
Пікірлер: 15
can you make this work in Tableau Online? I can't edit the set :(
Thanks sir
@DataVizCanvas
Жыл бұрын
You are welcome 😊
Great!👌👌
@DataVizCanvas
Жыл бұрын
Thanks Hamaza for your feedback and supporting my channel 🙂
Nice video! 2:17 Can you accomplish the same thing if you were using filter instead of parameter?
@DataVizCanvas
Жыл бұрын
Top N and bottom N you can achieve using filter but it wont be dynamic. For dynamic selection we need parameter. Hope that helps :-)
Thank you. Is there any workaround to create top N vs Others of subcategory in date-region-category-subcategory
@DataVizCanvas
Жыл бұрын
Hi Aryo, You can apply the same logic on subcategory (Dimension) and with any measure value. When you apply any filter on the data then make sure you are referring to tableau order of operations. Please try and let me know in case of any issues. Cheers! Gurpreet
Great work. Can you please explain how you got the bar placed in the middle and how The top N and bottom B are facing opposite direction. Thank you.
@DataVizCanvas
Жыл бұрын
Hi I am not clear with your question but please check the below timestamps in the video where i have explained how I have used sets to show top N , bottom N and both of them together . Hope that helps. 02:49 - How to show Top N values 06:26 - How to show Bottom N Values 07:29 - How to show Top N & Bottom N values combined in tableau 08:57 - How to show Top N vs Other in the form of Bar Chart
@ClareWilliams-ty5lq
Жыл бұрын
Hi@@DataVizCanvas Thank you for your quick response. I was able to achieve the same step in your tutorial using the superstore data for top & bottom single and combined set. But when I tried with another data, to find the sales of top and bottom selling product, Each time I drag sales to column the x-axis rage start from 0M to 60M and it does not include the minus range. Hence I was unable to get the combined top and bottom in one visual facing opposite direction. I think that is because the data sales do not include a minus rage. Is there another trick to go around this?
Could you please help me understand how I can find "Create Set Menu" (4:33)... In Tableau public I chose a field "Create Set", but after that immediately I saw new Set... without Menu... Why?
@DataVizCanvas
Жыл бұрын
Try using tableau desktop and let me know if you still face the same issue.
@romanvasiura6705
Жыл бұрын
@@DataVizCanvas In Tableau Desktop it works properly. Thank you!