Creating Waffle Chart Multiples in Tableau
In a previous article, we showed how to create waffle chart from a single percentage, without extra data table and without table join. Also the labeling is automated instead of manual, comparing to other approaches.
Creating Waffle Chart from a Single Percentage in Tableau
Waffle chart is popular for visualizing a single percentage. How can we create such a chart?
Here are the steps. The example data source has a single data record.
1.Union the data source with itself.
Thus the data source has two records now.
Creating Hierarchical Bar Chart in Tableau
Usually when we create a bar chart with 2 hierarchical dimensions such as Category and Sub-Category, we will have bars at the Sub-Category level and roll-ups at the Category level. Here is a chart we can create easily.
This is simple but it doesn't show the hierarchical relationship very well.
Hiding Subtotals at Single Subcategory in Tableau
I was alerted by an old request in Tableau forum dated year 2012.
https://community.tableau.com/ideas/1364
Today I found a solution for it. It needs 5 calculated fields, plus conditional formatting.
Making Label Text Wrap in Tableau
In Tableau text fields, such as text label or tooltips, there is no text wrap option. When a text label is long, we wish we can have it. Here we are going to show that we can make it happen.
In one project, we have limited space for text labels. That means, we have limits on both width and height.
Accessing Excel Files on SharePoint from Tableau
Recently, for the first time I had to connect to an Excel file on a SharePoint site.
Creating Bar Chart Multiples In One Sheet 2/2: Different Measures
In the previous post, we showed how to create bar chart multiples in a single sheet with the same measure. Here we are going to show you how to do this for different measures. Using the Superstore data set, we are going to show bar chart multiples for Sales, Profit and Profit Ratio per Subcategory.
Creating Bar Chart Multiples In One Sheet 1/2: Same Measure
A friend of mine asked me how to create a bar chart in the style of Tableau Prep. Another important requirement is: It has to be in one sheet.
This is actually a series of bar charts with each in its own column. Theoretically this can be done on a dashboard with multiple sheets.
Using Color to Reveal More Insights #TweakThursday 42
Coloring does make a difference, big or small depending on cases.
I noticed Yang Yu of Shanghai made a great viz and won Viz of the Day a couple of days ago. It required a lot of work to get the data set pulled from Open Street Map.
Customizing Subtotals and Grand Totals in Tableau
In one of the viz designs, we are using a data set that already includes the running sum, which is precalculated to save us some computations.
4Annotating Dual Axis with Alternative Color Legend #TweakThursday 41
A regular color legend can be boring. We can do it a little creatively.
Just opened the fresh Mary Meeker Internet Report 2019. The charts are evidently created using Tableau. I noticed that one of the dual axis charts (Silde #14) was hard for me to read. There is no color legend.
A Divide-n-Conquer Approach to Counting Word Occurrence
In the social data project #PreppinData Week 9 in 2019, there is an interesting project on counting word occurrences in customer complaints. It coincides with a project at my work. So, I started my first ever Tableau Prep project. It is a wild ride. Quite satisfying non the less.
Sorting Stacked Bars in Tableau
Someone came up with a question: how to sort stacked blocks within each stacked bar?
Each bar is a stack of small blocks of various sizes. Usually the blocks are all sorted by the same category, uniformly across all the bars.
256 Cellular Automata in One Sheet
It is a little over one year a ago when I created a mobile version of cellular automata in 256 rules in Tableau. Recently in the thought of a similar project, I went back to understand how I did it last year. Oh boy, I almost have to retrain myself to understand all the gory details.
Creating Polygon Hex Maps in Tableau
Hex map is quite popular for representing US geography in Tableau. Some asked how to create one for their own country or region. So here we will show the basic steps.
Hex map is a simplified way to represent a real map. It's an approximation.
Creating Joy Plot in Tableau With Fewer Steps
A few days ago, the Viz of the Day on 3/13/2019 is made of Joy Plot, authored by David Velleca. Quite a joy to look at for sure. After some digging, I found that it is based on an approach proposed by Ken Flerlage. It uses data scaffolding techniques with a few extra tables.
How Amazon failed to deliver: Analytical lessons
I had a few unpleasant experiences with Amazon delivery service recently. And it happened more than once. There seems to be an oversight by Amazon's data analysis team. If you are from Amazon, you may help me understand how Amazon's analytics is done.
Polygon-based US Hex Map Revisited
Rody Zakovich created a polygon-based hex map because he found that the shape-based hex map (created by Matt Chambers) can be hard to align and scale.
By looking into Rody's template, I found something to tweak. I created here two versions of the hex map. Both uses smaller data sizes.
Visualization, Data and Tableau Eco System
Recently I was invited to give a talk at PASS http://www.pass.org a non-profit organization of database professionals. Here is the video.