[Evergreen-general] Most Circulations in Past Year

[Deanna Frazee]

Many thanks, Terran and Lindsay!  I think you have set me on the right path, and I will know shortly since I am getting ready to see if I can corral the information we need.

Deanna


From: Evergreen-general <evergreen-general-bounces at list.evergreen-ils.org> On Behalf Of Lindsay Stratton via Evergreen-general
Sent: Thursday, January 27, 2022 2:45 PM
To: Terran McCanna <tmccanna at georgialibraries.org>; Evergreen Discussion Group <Evergreen-general at list.evergreen-ils.org>
Subject: Re: [Evergreen-general] Most Circulations in Past Year

Hi Deanna,

To add to Terran's suggestion - if your library anonymizes/ages data, you will probably want to use the Combined Aged and Active Circulations source! That will ensure you get all the circs, not just those still associated with patrons.

Lindsay



Lindsay Stratton
Systems Librarian
Westchester Library System
570 Taxter Rd., 4th Floor
Elmsford, NY 10523
lstratton at wlsmail.org<mailto:lstratton at wlsmail.org>


On Thu, Jan 27, 2022 at 3:36 PM Terran McCanna via Evergreen-general <evergreen-general at list.evergreen-ils.org<mailto:evergreen-general at list.evergreen-ils.org>> wrote:
Hi Deanna,

I would probably do something like this, which only looks at the items that actually circulated:

Source: Circulation

Filters:
Checkout / Renewal Library (In List)
Checkout Date/Time (Transform to Date, change Operator to Between)
(and then maybe filters for shelving location and/or call number to focus on particular sections, depending on the size of the library)

Display:
(whichever display you fields you want here - I usually do owning library, shelving location, call number, title, author, barcode)
Circ ID (Transform to Count - this will total up the number of circs for each item).

I hope that helps,
Terran



[https://lh6.googleusercontent.com/fJoF6o0xl9XByQZmykva1sv2n_cKGUXL_BH4crkpJgSqDu-yU7-5jIypuXBsEuoXCCBAAUQ2jUztJlZDNUVOlwl1bWZIL1W4wmFuEEzCLVMxUyhzdkV7jkcRcdZZni2z8OPz4xJA]

Terran McCanna, PINES Program Manager

________________________________

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341

(404) 235-7138 | tmccanna at georgialibraries.org<mailto:tmccanna at georgialibraries.org>

http://help.georgialibraries.org | help at georgialibraries.org<mailto:help at georgialibraries.org>


[https://lh4.googleusercontent.com/77DYzuoZ-zqC0pyQuYNKCrWaPuOANHsYTJze0JxE_iK4yW2sCswywdPCC8hCHOIyhO7KKIO-L6dlN1wIqdHFcyJmTa1fuc5Ok34dR8FQTtZHawpgNmovGxjg9RS0-WI74dFDHw0_]<https://www.facebook.com/georgialibraries>[https://lh4.googleusercontent.com/1bKX66xWgHe-v5FD5l-hYX4FrZDXi1Y2aKr0DZLDA_oEHy7s01WVqgVilQcwGBzRQZAg3yOePmZncGwtiYGSgavOkb0T5Tj3c46iUJ7ZE7h-MUEhVwXQs7Oc3cahIYMN2SGlk_6b]<https://www.twitter.com/georgialibs>[https://lh3.googleusercontent.com/U7PH5YIQnuRvbeMnGOlJAEPAre7Zqx_I6IDJAtJVwUDCp1-TmjSwP_x21qKx8ApsbcaILIuSpL3Pzau2Rz-phR_4IPcLR4LrIha_JMDHqombNtsfa1uhXcYS02QWTAyYqSf3ES_n]<https://www.instagram.com/georgialibraries/>

Join our email list<http://georgialibraries.org> for stories of Georgia libraries making an impact in our communities.



On Thu, Jan 27, 2022 at 3:05 PM Deanna Frazee via Evergreen-general <evergreen-general at list.evergreen-ils.org<mailto:evergreen-general at list.evergreen-ils.org>> wrote:
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<mailto: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<mailto: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/>

_______________________________________________
Evergreen-general mailing list
Evergreen-general at list.evergreen-ils.org<mailto:Evergreen-general at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
_______________________________________________
Evergreen-general mailing list
Evergreen-general at list.evergreen-ils.org<mailto:Evergreen-general at list.evergreen-ils.org>
http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20220127/f56ed2f3/attachment-0001.html>