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 <[email protected]> On Behalf Of Lindsay Stratton via Evergreen-general Sent: Thursday, January 27, 2022 2:45 PM To: Terran McCanna <[email protected]>; Evergreen Discussion Group <[email protected]> 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 [email protected]<mailto:[email protected]> On Thu, Jan 27, 2022 at 3:36 PM Terran McCanna via Evergreen-general <[email protected]<mailto:[email protected]>> 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 | [email protected]<mailto:[email protected]> http://help.georgialibraries.org | [email protected]<mailto:[email protected]> [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 <[email protected]<mailto:[email protected]>> 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) [email protected]<mailto:http://[email protected]> www.killeentexas.gov<http://www.killeentexas.gov/> From: Evergreen-general <[email protected]<mailto:[email protected]>> On Behalf Of Deanna Frazee via Evergreen-general Sent: Thursday, January 27, 2022 1:07 PM To: 'Evergreen Discussion Group' <[email protected]<mailto:[email protected]>> 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) [email protected]<mailto:http://[email protected]> www.killeentexas.gov<http://www.killeentexas.gov/> _______________________________________________ Evergreen-general mailing list [email protected]<mailto:[email protected]> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general _______________________________________________ Evergreen-general mailing list [email protected]<mailto:[email protected]> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
_______________________________________________ Evergreen-general mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
