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 lstrat...@wlsmail.org On Thu, Jan 27, 2022 at 3:36 PM Terran McCanna via Evergreen-general < evergreen-general@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 > > > 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 | tmcca...@georgialibraries.org > > http://help.georgialibraries.org | h...@georgialibraries.org > > <https://www.facebook.com/georgialibraries> > <https://www.twitter.com/georgialibs> > <https://www.instagram.com/georgialibraries/> > <https://www.twitter.com/georgialibs> > > 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@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) >> >> dfra...@killeentexas.gov >> >> www.killeentexas.gov >> >> >> >> >> >> >> >> *From:* Evergreen-general < >> evergreen-general-boun...@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@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) >> >> dfra...@killeentexas.gov >> >> www.killeentexas.gov >> >> >> _______________________________________________ >> Evergreen-general mailing list >> Evergreen-general@list.evergreen-ils.org >> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >> > _______________________________________________ > Evergreen-general mailing list > Evergreen-general@list.evergreen-ils.org > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
