Join 4.4K subscribers who receive weekly, bite-sized data lessons, and practical SQL and Tableau tutorials | Subscribe for additional resources, and start with free tutorials at youtube.com/sqlbelle
What percentage of something account for 80% of something else? | Tableau Tutorial
Hello,
I hope this message finds you well. Thank you for your support these past few years. It's been great receiving your kind words of support and encouragement.
I've been recently asked to get the percentage of something that accounts for something else ... like is it true that 80% of sales come from 20% of customers? While working through this, I realized I didn't have the steps documented yet in any of my YouTube tutorials. So this is for you - if ever you need to answer this same question in the future. Please note, however, that what I present is just one approach. I am certain you will find different variations of this approach that will get the same result.
Whether you’re aiming to analyze 8% or 80% of your data, this tutorial can help. This tutorial not only teaches you the technical steps but also helps clarify the logic behind each step, ensuring a deeper understanding of data analysis in Tableau and any potential pitfalls.
This technique will work with any data set, so you don’t have to be using sales data. You could be looking at number of complaints, number of patients, fundraising dollars, etc.
YouTube Video Tutorial
https://youtu.be/AnEpcU7ddDs
Additional topics and concepts covered:
- parameters
- row-level calculations
- aggregate calculations
- LOD expression
- table calculations (ATTR, INDEX, Running Total, WINDOW_COUNT)
- secondary table calculations - and more …
Superstore Data Set (Excel):
https://data.world/sqlbelle/sample-superstore-2023
Starter Workbook: https://public.tableau.com/app/profile/sqlbelle/viz/Whatpercentofourcustomersaccountfor80sales-STARTER/Tutorial
Hope you find this tutorial helpful, and I wish you a lovely week ahead.
Donabel
PS
Since this tutorial has a lot of calculations, you may find these other tutorials helpful to revisit:
Parameters https://www.youtube.com/watch?v=0Uar_D57QhU
LOD https://www.youtube.com/watch?v=yush1yNz9VM
Basic Calculations https://www.youtube.com/watch?v=QimVQl5AoYM
Table Calculations https://www.youtube.com/watch?v=3_DeQdE25Bc
Order of Operations https://www.youtube.com/watch?v=BrpOBoLhmlM
12 Common Tableau Errors https://www.youtube.com/watch?v=8eQK1IcYiWs
Hi! I'm sqlbelle!
Weekly bite-sized data tips, lessons and practical tutorials. 5 minutes to read.
Join 4.4K subscribers who receive weekly, bite-sized data lessons, and practical SQL and Tableau tutorials | Subscribe for additional resources, and start with free tutorials at youtube.com/sqlbelle
Hello Reader, Greeting here Tableau Tip - working with untidy data Imagine you have to work with a lot of text, for example, needing to extract the hashtags or reformat phone numbers easily. Does Tableau have the functionality to help you? Sample untidy data The answer is yes - with regex. What is Regex? Regex, or Regular Expressions, is a powerful way to work with text. Think of it as a search tool that goes way beyond finding simple text matches. It finds patterns within text, which can be...
Hello Reader, I hope you had a great week this week. Here are the data tidbits for this week. Tableau Tip - Crosstab Here is a simple but overlooked Tableau Tip. Look at your data in crosstab. Benefits of Crosstab view: Provides a clear view of raw data numbers, which can help in your validation processes. Particularly useful for verifying complex calculations such as table calculations or LOD calculations. In Tableau, you can right-click on your view name (the tab at the bottom of the...
Hello Reader, Hope you are having a wonderful day. Here are the data tidbits for this week. Tableau Tip - Use your own color Do you know how you can use your own colors in Tableau? You can use a double-click trick: Double-click any entry in your color legend to bring out the “Edit Colors” window Double-click any entry under “Select Data Item” to bring out the “Select Color” window From the “Select Color” window, you can change color in the following ways Color slider Pick screen color RGB...