« Fun with Photos | Main | Easy way to clear a browser's cache »

Turning library reports into heat maps

At this time of year, two of the things that are often on my mind are annual reports and finding heat (can you believe how cold it's been lately?). Did you know it's easy to combine these things and find the hot spots within your reports?

Take the example of our report of circulation by time of day. You can fairly easily just study the numbers and figure out what your busiest day or time of day is. Using sorting can help somewhat with this task. But there's a lot of numbers on this report, which to many people is just a lot of noise.

If we simply add a bit of color to the numbers, all of that noise gets turned into signal and this makes patterns of interest really jump out. This is very easy to do. Here's how:

  1. Select the block of cells you want to map in color.

    In the example I'm using, I'm choosing only the columns "Mondays" through "Sundays". I'm leaving out the "Total" column because it will too heavily skew the results.

  2. Click the Conditional Formatting button on the Office ribbon.

  3. Choose Color Scales from the menu that opens.

  4. Choose a color scheme.

    For this report, I like the color scheme named "Red - Yellow - Green" (the second icon in the top row). This makes the highest numbers the reddest and the lowest numbers the greenest. Like this:


Performing this trick on the LINKcat (system wide) circulation by time report clearly shows that weekdays from 4:00 p.m. to 5:00 p.m. is our busiest time slot overall, with Mondays and Fridays being busiest. But it also highlights Saturday from 11:00 a.m. to 1:00 p.m., and Saturday in general as being a pretty busy day. To me, that wasn't obvious without the added colors.


Feed You can follow this conversation by subscribing to the comment feed for this post.

This is super cool!

(are there really hundreds of circs every day from 3-4am?)

The example data is our 2012 annual summary, so that's 52 weeks worth of data, combined. But yes, people do take advantage of Telecirc and LINKcat web renewal features 24 hours a day.

The comments to this entry are closed.