[Evergreen-general] Most Circulations in Past Year

[Terran McCanna]

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 | tmccanna at georgialibraries.org

http://help.georgialibraries.org | help at 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 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
>
> 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
>
> www.killeentexas.gov
>
>
> _______________________________________________
> Evergreen-general mailing list
> 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/2bad27d9/attachment-0001.html>