This view shows the min, max, and average values for the top and bottom of each rack. The actual table has 149 rows, but I cropped it for space purposes. You’ll quickly realize that while this more detailed information is much more useful than yesterday’s table, it is difficult to extract any actionable information if we can’t sort this data. Here is the same data table sorted to show the 20 hottest rack and 20 coldest based on their average.
Takeaways
- 13 racks average above the upper thermal limit of 80.6°F and 1 rack averages below the lower limit of 64.4°F. The hot and cold spots have been identified.
- On Day 1 we saw that the maximum rack top and rack bottom temperature were both 88.7°F. Our question was if they came from the same location. We now see that they don’t – rack 115 has a max top temp of 88.7°F and rack 20 has a max bottom temp of 88.7°F.
Issues
- While this information is valuable, presenting it in a table is still overwhelming and difficult to quickly extract the most useful pieces of information.
- Tables are useful for presenting static information but not very good at showing time dependent patterns. Min, max, and average provide a good summary for the entire time period, however they cannot reveal any time dependencies.
Previous Posts
About the Data
Day 1 – From 10,000 Feet
Today – Rack by Rack
Tomorrow – Learn to Love Graphs




[...] Posts About the Data Day 1 – From 10,000 Feet Day 2 – Rack by Rack Day 3 – Learn to Love Graphs Day 4 – Wordle Today – Bubble Charts Tomorrow [...]