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.

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