<div dir="ltr"><div dir="ltr"><div>Hi Deanna,</div><div><br></div><div>I would probably do something like this, which only looks at the items that actually circulated: <br></div><div><br></div><div>Source: Circulation</div><div><br></div><div>Filters: <br></div><div>Checkout / Renewal Library (In List)<br></div><div>Checkout Date/Time (Transform to Date, change Operator to Between)</div><div>(and then maybe filters for shelving location and/or call number to focus on particular sections, depending on the size of the library)</div><div><br></div><div>Display: </div>(whichever display you fields you want here - I usually do owning library, shelving location, call number, title, author, barcode)</div><div>Circ ID (Transform to Count - this will total up the number of circs for each item).</div><div><br></div><div>I hope that helps,</div><div>Terran<br></div><div dir="ltr"><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br><div dir="ltr" style="margin-left:0pt"><table style="border:medium none;border-collapse:collapse"><colgroup><col width="94"><col width="530"></colgroup><tbody><tr style="height:123pt"><td style="vertical-align:top;padding:5pt"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh6.googleusercontent.com/fJoF6o0xl9XByQZmykva1sv2n_cKGUXL_BH4crkpJgSqDu-yU7-5jIypuXBsEuoXCCBAAUQ2jUztJlZDNUVOlwl1bWZIL1W4wmFuEEzCLVMxUyhzdkV7jkcRcdZZni2z8OPz4xJA" style="margin-left:0px;margin-top:0px" width="75" height="75"></span></span></p></td><td style="vertical-align:top;padding:5pt"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span style="font-size:11pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Terran McCanna, PINES Program Manager</span></p><hr><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"></span><span style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Georgia Public Library Service | University System of Georgia</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">(404) 235-7138</span><span style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> | <a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a> <br></span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><span style="font-size:9pt;font-family:Verdana;color:rgb(30,67,155);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><a href="http://help.georgialibraries.org" target="_blank">http://help.georgialibraries.org</a> | <a href="mailto:help@georgialibraries.org" target="_blank">help@georgialibraries.org</a><br></span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;margin-left:9pt"><a href="https://www.facebook.com/georgialibraries" style="text-decoration:none" target="_blank"><span style="font-size:9pt;font-family:Verdana;color:#1155cc;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh4.googleusercontent.com/77DYzuoZ-zqC0pyQuYNKCrWaPuOANHsYTJze0JxE_iK4yW2sCswywdPCC8hCHOIyhO7KKIO-L6dlN1wIqdHFcyJmTa1fuc5Ok34dR8FQTtZHawpgNmovGxjg9RS0-WI74dFDHw0_" style="margin-left:0px;margin-top:0px" width="36" height="36"></span></span></a><a href="https://www.twitter.com/georgialibs" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Verdana;color:#1155cc;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh4.googleusercontent.com/1bKX66xWgHe-v5FD5l-hYX4FrZDXi1Y2aKr0DZLDA_oEHy7s01WVqgVilQcwGBzRQZAg3yOePmZncGwtiYGSgavOkb0T5Tj3c46iUJ7ZE7h-MUEhVwXQs7Oc3cahIYMN2SGlk_6b" style="margin-left:0px;margin-top:0px" width="35" height="35"></span></span></a><a href="https://www.instagram.com/georgialibraries/" style="text-decoration:none" target="_blank"><span style="font-size:11pt;font-family:Verdana;color:#1155cc;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:34px;height:34px"><img src="https://lh3.googleusercontent.com/U7PH5YIQnuRvbeMnGOlJAEPAre7Zqx_I6IDJAtJVwUDCp1-TmjSwP_x21qKx8ApsbcaILIuSpL3Pzau2Rz-phR_4IPcLR4LrIha_JMDHqombNtsfa1uhXcYS02QWTAyYqSf3ES_n" style="margin-left:0px;margin-top:0px" width="34" height="34"></span></span></a><a href="https://www.twitter.com/georgialibs" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap"></span></a></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt"><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt;text-align:center"><a href="http://georgialibraries.org" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Verdana;color:rgb(17,85,204);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-size:10pt;font-family:Verdana;color:rgb(0,0,0);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:10pt;font-family:Verdana;color:rgb(67,67,67);background-color:rgb(255,255,255);font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p></td></tr></tbody></table></div><br></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 27, 2022 at 3:05 PM Deanna Frazee via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="overflow-wrap: break-word;" lang="EN-US">
<div class="gmail-m_-6090199907998215511WordSection1">
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:14pt;font-family:"Bahnschrift SemiBold Condensed",sans-serif;color:rgb(31,73,125)">Deanna Frazee<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">Director of Library Services</span><span style="font-size:10pt;font-family:"Matura MT Script Capitals";color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">Killeen Public Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">City of Killeen, Texas<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">254-501-8995 (office)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">254-501-7704 (fax)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)"><a href="mailto:http://dfrazee@killeentexas.gov" target="_blank">dfrazee@killeentexas.gov</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)"><a href="http://www.killeentexas.gov/" target="_blank">www.killeentexas.gov</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Evergreen-general <<a href="mailto:evergreen-general-bounces@list.evergreen-ils.org" target="_blank">evergreen-general-bounces@list.evergreen-ils.org</a>>
<b>On Behalf Of </b>Deanna Frazee via Evergreen-general<br>
<b>Sent:</b> Thursday, January 27, 2022 1:07 PM<br>
<b>To:</b> 'Evergreen Discussion Group' <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>><br>
<b>Subject:</b> [Evergreen-general] Most Circulations in Past Year<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi, Adam,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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?
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks!<u></u><u></u></p>
<p class="MsoNormal">Deanna<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:14pt;font-family:"Bahnschrift SemiBold Condensed",sans-serif;color:rgb(31,73,125)">Deanna Frazee<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">Director of Library Services</span><span style="font-size:10pt;font-family:"Matura MT Script Capitals";color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">Killeen Public Library<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">City of Killeen, Texas<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">254-501-8995 (office)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)">254-501-7704 (fax)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)"><a href="mailto:http://dfrazee@killeentexas.gov" target="_blank">dfrazee@killeentexas.gov</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:rgb(31,73,125)"><a href="http://www.killeentexas.gov/" target="_blank">www.killeentexas.gov</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote></div></div>