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.

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.

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.

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.

3

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.

9

Recently, for the first time I had to connect to an Excel file on a SharePoint site.

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.

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.

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.

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.

4

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.

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.

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.

8

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.

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.

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.

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.

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.

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.

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.