Ability to find the most checked out item in a year
Ability to find the most checked out item in a year
Please add a simple way in Sierra to report the most checked out item for a selected year, including the option to show the top five checked out items.
Currently, this is very difficult or impossible to do directly in Sierra because checkout totals are not stored in a way that allows staff to easily rank items by circulation count for a specific year. Create Lists can find items based on fixed fields, item data, and limited transaction-related criteria, but it cannot easily produce a yearly “most checked out” ranking by title or item.
This would help libraries quickly identify high-demand materials, support collection development, justify purchases, evaluate trends, and answer common administrative questions without needing external reports, database access, or manual workarounds.
Al Berry II
shared this idea
-
Jeremy Goldstein
commented
Are you interested in item level details or title?
By item if you can use the year to date circ fields (we actually can't because they're based on fiscal year instead of calendar year in our system) you can search for items with a count > some reasonably high number to provide you with a limited list and then sort the results on that field.
By title, none of the tools within Sierra itself allow for summing up the counts from attached items so yeah you'd have to export the data to excel or rely on SQL or Decision Center. Maybe this is something that would be achievable in Vega Reports to come.