[Evergreen-general] Most Circulations in Past Year

[Lindsay Stratton]

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


On Thu, Jan 27, 2022 at 3:36 PM Terran McCanna via Evergreen-general <
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
>
>
> 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
>>
> _______________________________________________
> 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/bd5a138d/attachment.html>