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 | [email protected] http://help.georgialibraries.org | [email protected] <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 < [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] > > www.killeentexas.gov > > > > > > > > *From:* Evergreen-general < > [email protected]> *On Behalf Of *Deanna > Frazee via Evergreen-general > *Sent:* Thursday, January 27, 2022 1:07 PM > *To:* 'Evergreen Discussion Group' < > [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] > > www.killeentexas.gov > > > _______________________________________________ > Evergreen-general mailing list > [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
