Analytics Made Accessible

View Original

Order Your Data with Intention – Part 3

Before/After slide transformation. Before slide (left) shows a (rainfall) column chart showing monthly patterns in average rainfall in millimeters (mm) in the Ahanta West Region of Ghana. Rainfall values are sorted in ascending order. The After slide shows the same data sorted in chronological order. Peak rainfall months (April, May, and June) are emphasized while all other bars were set to 40% transparency.

By default, most analytics and business intelligence tools will keep your data in the order they appear in the underlying file. However, defaults are not always the best option. Arranging and displaying data in a meaningful order can mean the difference between a clear and compelling chart versus a confusing one. In this series of posts, I share three scenarios where displaying data in an order that supports interpretation can help you tell a more compelling story. This post will discuss chronological sorting.

 

Scenario #3: Ordering Data Chronologically

In my first post, I talked about data sorting and how arranging (data) values in ascending or descending order can enhance your visualization. However, what if the data cannot meaningfully be sorted by values?

Let me show you an example.

Consider a visualization that displays the amount of rainfall a region receives. The (rainfall) column chart shows monthly patterns in average rainfall in millimeters (mm) in the Ahanta West Region of Ghana.

Image of a (rainfall) column chart showing monthly patterns in average rainfall in millimeters (mm) in the Ahanta West Region of Ghana. Rainfall values are sorted in ascending order: February: 57 mm; August: 62 mm; September 64 mm; January; 66 mm; March 73 mm; December 79 mm; November: 104 mm; October 146 mm; July: 217 mm; April: 229 mm; May: 242 mm; and June 373 mm.

Based on the values, June is the month with the most rainfall in the Ahanta West Region (373 millimeters). But because the months are not sorted in chronological order, you cannot determine whether there are any seasonal rainfall patterns.

A month is a unit of time (or date range). And to accurately depict trends over time, dates (e.g., month, quarters, years) should be plotted in chronological order (oldest to newest date).

Image of a (rainfall) column chart showing monthly patterns in average rainfall in millimeters (mm) in the Ahanta West Region of Ghana. Rainfall values are sorted in (monthly) chronological order: January; 66 mm; February: 57 mm; March 73 mm; April: 229 mm; May: 242 mm; June 373 mm; July: 217 mm; August: 62 mm; September 64 mm; October 146 mm; November: 104 mm; December 79 mm.

Once the data are appropriately sorted, monthly trends can be easily identified and emphasized.

Image of a (rainfall) column chart showing monthly patterns in average rainfall in millimeters (mm) in the Ahanta West Region of Ghana. Peak rainfall months (April, May, and June) are emphasized while all other bars were set to 40% transparency. Rainfall values are sorted in (monthly) chronological order: January; 66 mm; February: 57 mm; March 73 mm; April: 229 mm; May: 242 mm; June 373 mm; July: 217 mm; August: 62 mm; September 64 mm; October 146 mm; November: 104 mm; December 79 mm.

If your data include time periods or date ranges, consider sorting it in chronological order.

Don't forget to read the other two posts in the series sorting data values and ordering chart series.

** Data used in this post can be downloaded from the United Nations Development Programme's Reports and Publications Repository. **