[Evergreen-general] Most Circulations in Past Year

[Deanna Frazee]

This is what happens when I get interrupted with a request to create a report just as I am emailing someone.  I would appreciate any help that anyone-even those not named Adam-can give to help me figure out how to gather this data.

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/>



From: Evergreen-general <evergreen-general-bounces at list.evergreen-ils.org> On Behalf Of Deanna Frazee via Evergreen-general
Sent: Thursday, January 27, 2022 1:07 PM
To: 'Evergreen Discussion Group' <evergreen-general at list.evergreen-ils.org>
Subject: [Evergreen-general] Most Circulations in Past Year

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/daaf667f/attachment.html>