What are jitter plots (strip plots) and how to make them in Tableau
Read MoreHow to Create Jitter Plot (Strip Plot) in Tableau

data visualization
What are jitter plots (strip plots) and how to make them in Tableau
Read MoreMy personal experience of getting Tableau Desktop Qualified Associate certification and what you can learn from it
Read MoreStep by step guide on what are sparklines and how to create sparklines in tableau
Read MoreMy personal scores for 62 geospatial #ironviz feeder entry visualisations.
Read MoreWhat is arc diagram and step by step tutorial on how to create in Acr Chart in Tableau!
Read MoreHow I learned Tableau and the engineer vs the designer dilemma!
Read MoreStep by step tutorial on how to create Population Pyramid in Tableau and how it can be used in demographic and marketing analysis.
Read MoreStep by step tutorial on how to create funnel chart in Tableau and when a funnel chart should be used.
Read MoreLearn how to create donut chart in Tableau and when a donut chart should be used (Video tutorial embedded)
Read MoreStep by step guide on how to create KPI Dashboard in Tableau
Read MoreIn this post, you will learn how to create a chart like this where the category 'Other' is dynamically self-adjusting itself based on the data. Data for this post can be downloaded from here.
The colored Others bar is self adjusting, that means it can combine categories automatically which are small enough to not to be shown separately
Following the Pareto's famous 80:20 rule, most of the value of anything is contributed by a handful of members, let's say 80% of sales by 20% customers or 80% of tweets by 30% users. And in all the Pareto charts it leaves a looooong right tail of small contributors.
Here is an example from my Twitter Dashboard for Tableau Conference which tracked #data16 conversation. I wanted to show how many tweets are being from which App Platform. The raw data gave me a picture like this:
See, most of my interest is in the left side head and that long tail of small values is just boring. Can't I somehow get rid of this?
Gosh! That long boring tail making my chart look so ugly and boring, and most importantly not leaving enough room to focus on key areas of charts. What can I do? Here are my possible solutions
Well, I don't want to put a scroll bar on an elegant social media dashboard. What what if after grouping those items in tail as Others manually, some new items come tomorrow after I refresh the data? I don't want to keep grouping those new values manually forever. Next, I would be very uncomfortable to filter those small values out for two reasons: it wouldn't show a 100% picture, second who knows when any of those small value gets a significant large number tomorrow, but I won't be reporting it, because I assumed it now that it is small enough! So what shall we do? Here is what I did:
I created a category called 'Others' which will contain all those small factors on the tail and group them together. How did I define small? Well, this is a case of trial and error, in this case, I did not want to see any tweet platform separately which contributed to less than 2.5% of total tweets. In your case this threshold can be different but I am sure, you will find an optimized one. Here are the steps to follow:
IF {FIXED [App] : SUM([Number of Records])} / {SUM([Number of Records])} < .025 THEN 'Others' ELSE [App] END
There you go! You just created a self adjusting 'Others' category which changes itself when your data changes :) Happy Data Vizzing!
With this week's #MakeoverMonday Challenge, I have started loving it even move. This week we visualized data (Courtsey: McKinsey and LeanIn.org) on gender inequality at workplaces in the United States
Read MoreMy story on how I took my first #MakeoverMonday DataViz Challenge. And absolutely loved it.
Read More