[Evergreen-general] Most Circulations in Past Year

[Deanna Frazee]

Hi, Adam,

I have been trying to figure out a way to see how many times each book circulated in 2021 or, in lieu of that, in the past 12 months.  I know this data is somewhere because I can see it on the Quick Summary tab when I view an item's history.  There is a column that says "Total Circs - Current Year."  Would I be correct in assuming that "Current Year" is equal to the past 12 months in this case?

I cannot figure out from which table this information is drawn.  I suspect I also need to know how to query it just right to get the timeframe I want.  Can you point me in the right direction?

Thanks!
Deanna

Deanna Frazee
Director of Library Services
Killeen Public Library
City of Killeen, Texas
254-501-8995 (office)
254-501-7704 (fax)
dfrazee at killeentexas.gov<mailto:http://dfrazee@killeentexas.gov>
www.killeentexas.gov<http://www.killeentexas.gov/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20220127/f06c7fbe/attachment.html>