Showing Partial Progress with Donut Chart
These are slight variations from Ryan Sleeper's blog and Andy Kriebel's blog on designing donut chart. Please refer to Andy's blog for the step-by-step tutorial.
By making part of the circle white, it shows a stronger contrast between actual and distance-to-goal.
Selected as Viz of the Day on Dec 19, 2014
The Viz on Turing Award winners just got selected as the Viz of the Day on Dec 19, 2014.
This is a nice little Christmas gift.
A Viz on Turing Awards 1966-2020
[Updated on 6/15/2021. Click image below to go to the interactive version.
4Simply Copy-n-Paste, Baby!
My colleague Sandeep came over to tell me how marvelous a little trick I told him the other day is: copy and paste. Sandeep is an experienced Tableau designer and he has designed a few sophisticated dashboards. If he didn't know it, I thought it might be worthwhile to write it down.
2Filtering those spaghetti in bump chart
Bump chart is a two-dimensional ranking visualization tool. It allows us to visualize data rank by one dimension which changes along the other dimension. One example is the soccer league ranking by team along weekly schedule.
Selected as Best of the Tableau Web in October 2014
My post "Color your way to visual finesse" is selected as the "Best of the Tableau Web in October 2014" by Tableau Software:
http://bit.ly/best-tableau-web-october-2014
This follows an earlier recognition in August 2014:
http://bit.ly/best-of-tableau-web-august-2014
Thanks, Tableau community!
Further into causes of death in US: The geographical difference
Your death depends on where you live. This is not surprising. We learnt it in things like "Gun, Germs and Steel" the book. Now we have serious data to prove it.
Recently, a viz of the day showed the causes of death in USA. Andy Kriebel published a makeover of the viz.
Towards A Perfect Funnel Chart
Following the steps in this video, I can create a funnel chart.
http://www.tableausoftware.com/learn/tutorials/on-demand/funnel-charts
But, there are a few things that the trainer didn't elaborate in order to make a complete funnel chart in practice. So here you go.
Head-n-Tail Analysis (Part 2): 30 sec to Dashboard
[Head-n-Tail Analysis (Part 1): The Toolkit]
In Part I, I explained what head-n-tail analysis is. Here I will show how you can make an analysis dashboard of your own data in no time.
To make it simple, I made a dashboard template (on English Premiere League teams TV revenue) for download.
Head-n-Tail Analysis (Part 1): The Toolkit
[Head-n-Tail Analysis (Part 2): 30 sec to Dashboard]
What is head-n-tail analysis? It consists of top ranking and tail aggregation.
Recently I have had a few different analysis cases which can all use the same simple yet powerful methodology.
Color your way to visual finesse
The color palette we use the most in Tableau is either discrete or gradient. Discrete colors are applied to categorical data or dimensions. Gradient colors are applied to numerical data or measures.
Here we try to go beyond the dichotomy of discrete and gradient.
Color Range Definition (3): Rendering problem of diverging color palette
Update: Tableau 8.2.4 partially fixed the problem. Still, the fix is biased towards high color. The center is not respected some times. Filed a further bug.
Recognized as Best of Tableau Web August 2014
One of my blogs has been recognized as Best of Tableau Web August 2014.
http://www.tableausoftware.com/about/blog/2014/8/best-tableau-web-august-2014-32837
I am using Tableau to visualize its own inner working.
Story points in Tableau: Top Places of Origin for International Students in USA
I am trying out this new feature Story in Tableau by making a stack of worksheets and dashboards, reminiscent of Microsoft PowerPoint. To me, the story feature is creating a higher hierarchy: Story>Dashboard>Worksheet.
My first quick stab: International Students in USA's top 25 places of origin.
Color Range Definition (2): Tableau bug partially fixed in 8.2.2
In response to an issue I raised earlier in Juneļ¼
http://vizdiff.blogspot.com/2014/06/range-definiton-bug-in-color-editor.html
The bug is announced as fixed in Tableau Desktop 8.2.2:
http://www.tableausoftware.com/support/releases/8.2.2
"When the center value of a diverging color palette was set
Removing Unwanted Measure Names from Quick Filter(Part 2): less names more values
My earlier post on this subject seems really popular. I am a little surprised to say the least.
Here is another technique: Right-click in the Measures shelf and hide unused Measures. The unused measures will disappear from your quick filter.
Recap of Splunk Live 2014 at San Francisco
I struggled about whether to attend the breakfast session at Westin St Francis in downtown San Francisco at 7:30am. I am glad I made it. The chilly morning breeze helped clear my head. It is always chilly in the city and morning is a little chillier.
Revisit of 5 Rank Functions in Tableau (Part 2) : Rank and Percentile
[Note: Part 1 is at http://vizdiff.blogspot.com/2014/08/revisit-of-rank-functions-in-tableau.html]
In my last blog on rank functions in Tableau, I found out that the chart of rank() and rank_percentile() can exactly overlap each other, given the same scale.
Revisit of 5 Rank Functions in Tableau (Part 1)
[Note: Part 2 is at http://vizdiff.blogspot.com/2014/08/revisit-of-5-rank-functions-in-tableau.html]
There are multiple ways to rank data. Tableau provides five different rank functions.
La Liga vs Premier League 2012: Pareto Analysis
In my last post, I used a dynamic pie chart to visualize the revenue share between top N teams and the rest of the league. It gives a pretty strong visual cue about the share size for a given N. We can set any N (between 1-19) to see different shares.
Dynamic Pie Chart: Top N, Sorting Slices and Grouping Others
In a comment by TarikB at the end of Andy Kriebel's recent article, Tarik would like to see the revenue share of the top teams versus that of the rest of the league. It is where I got the inspiration to design a dynamic pie chart.
Premier League 13-14 TV+Commercial Revenue Analysis
This dashboard is an attempt to visualize the TV and commercial revenue spread among the 20 teams.
La Liga vs Premier League revenue comparison: The Dashboard
This dashboard is inspired by Andy Kriebel's latest Monday Makeover and a question in the comments by Tarik:
http://vizwiz.blogspot.com/2014/07/footballrevenue.html
The main features are:
- Lollipops vertically arranged to use the same revenue axis + top N team highlights.
Date Dimension: Four steps to a rolling calendar default to the latest date
Need of rolling calendar
As I stated in an earlier post, a rolling calendar is a better visualization tool than monthly calendar, especially for non-financial and dynamic data monitoring.
But its design is not so obvious using Tableau.
Need to define a default cover tab when publishing in Tableau
It's common that in one workbook we have multiple tabs. One of the tabs is supposed to be the cover tab or the default tab. We need a way to define or select one tab as the cover tab. Tableau always makes the one I am working on as the cover. That's not correct.
Color Range Definition (1): a bug in Tableau color editor
Update 2: This is announced as fixed in Tableau Desktop 8.2.2 but not in server
http://vizdiff.blogspot.com/2014/08/tableau-bug-fix-color-palette-range.html
Update 1: After communicating with Tableau support staff, the question came down to: whose color range definition to respect? The user's or t
Erratic behavior in Date quick filter with Show "All" Value in Tableau
http://kb.tableausoftware.com/articles/howto/filter-on-last-date-in-the-data-source
The above article is about a nice date filter that defaults to last date in the data source. For example, it allows us to always default to the current month.
A show-stopping bug in the color editor in Tableau 8.1.6
Update: Tableau just informed me that they will fix this in 8.2, which will be soon released.
----
When I select full color range AND set Center==End==Same_Value, it hangs and then crashes. In this example, Center==End==50. I know it's a little extreme, but.
Date Dimension: Rolling multi-weekly vs monthly calendar view
We are getting used to divide our time into years, months, weeks etc. This dictates many aspects of our life. We accept it without questioning and just go along with it.
Among all the date scales, month is kind of particular.
Removing Unwanted Measure Names from Quick Filter (Part 1)
[Update: If the following doesn't solve your problem, go to Part 2:
http://vizdiff.blogspot.com/2014/08/removing-unwanted-measure-names-from.html]
In one of my tasks, I needed to use measure names as quick filter, when we wanted to stack up multiple measures in one chart.