One simple design fix for the Olympic medal tally

Every Olympics, the same old debate emerges: Should the table be ordered by gold medals, or total medals? For instance, while the official website uses gold medal order, the New York Times uses total medal order, as shown here:

New York Times medal tally, ordered by total medal order

This seems to vary by country, presumably depending on which ordering is more favourable to that country. Here in Australia, it's always gold order, and in the US, it's total order (very important to always be ahead of China!).

Gold ordering seems more correct to me because using the total counts a bronze as good as a gold, which it obviously isn't. However, I don't care that much about the Olympics or national pride, so I don't have much emotional investment in which ordering is more correct.

What I do care about is good intuitive information display. The most frustrating thing about looking at these medal tables is that one has to take time examining it to determine the sort order it's using - both sort orderings use the same column ordering.

All this could be avoided if these tables adopted one simple convention:

Make the column order the same as the sort order.

Consider the New York Times table above. The column order is:

country - gold - silver - bronze - total

But the sort ordering is actually:

total - gold - silver - bronze - country

So why not just lay the table out that way?

total gold silver bronze country
77 25 30 22
United States
70 32 22 16
China
53 14 21 18
ROC
48 15 18 15
Great Britain
39 20 7 12
Japan
36 15 4 17
Australia
32 8 8 16
Germany
30 6 9 15
Italy
25 6 10 9
France
23 6 8 9
Netherlands
19 6 4 9
Korea
15 6 4 5
New Zealand

We can now read the sort order along the top. The primary sort column is on the left - the first column we look at. The data more naturally reads left-to-right (and top to bottom) like ordinary text. The effect has been enhanced with some subtle bars that illustrate the magnitude of the numbers within each column but also help convey the sort order. As we can see, the leftmost column is descending in magnitude.

Now for gold order.

gold silver bronze total country
32 22 16 70
China
25 30 22 77
United States
20 7 12 39
Japan
15 18 15 48
Great Britain
4 17 36
Australia
14 21 18 53
ROC
8 8 16 32
Germany
6 10 9 25
France
9 15 30
Italy
8 9 23
Netherlands
4 9 19
Korea
5 15
New Zealand

Once again, the table flows naturally from left to right. The most critical column is leftmost. The column labels now not only describe individual columns but the nature of the table as a whole.

This particular sort ordering has some ties in the primary column - this is highlighted by removing the redundant numbers within tied entries.

Using sort order as column order means that the tied groupings can be easily seen this way, and for multiple levels of tie (such as with the 6-gold group) a tree-like structure emerges showing the various tie groupings.

This is useful not just for olympic medals, but for all sorts of table displays - I explore the example of an airport departure information screen here.