There are some more robust solutions already for detailing holds checkouts vs. direct/browsing checkouts, but I put together a little something that just gives you some flat counts and percentages for the last full month at each branch. You could add other features to it pretty easily, but we were mostly interested in overall branch performance/collection usage for a branch that was recently relocated to a smaller, temporary location. In any case, here’s that query: