<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Bahnschrift SemiBold Condensed";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Many thanks, Terran and Lindsay! I think you have set me on the right path, and I will know shortly since I am getting ready to see if I can corral the information we need.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Deanna<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Evergreen-general <evergreen-general-bounces@list.evergreen-ils.org>
<b>On Behalf Of </b>Lindsay Stratton via Evergreen-general<br>
<b>Sent:</b> Thursday, January 27, 2022 2:45 PM<br>
<b>To:</b> Terran McCanna <tmccanna@georgialibraries.org>; Evergreen Discussion Group <Evergreen-general@list.evergreen-ils.org><br>
<b>Subject:</b> Re: [Evergreen-general] Most Circulations in Past Year<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Deanna, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Lindsay<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b>Lindsay Stratton</b><o:p></o:p></p>
<div>
<p class="MsoNormal"><b>Systems Librarian</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Westchester Library System<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">570 Taxter Rd., 4th Floor<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Elmsford, NY 10523<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:lstratton@wlsmail.org" target="_blank">lstratton@wlsmail.org</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, Jan 27, 2022 at 3:36 PM Terran McCanna via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="MsoNormal">Hi Deanna,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I would probably do something like this, which only looks at the items that actually circulated:
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Source: Circulation<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Filters: <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Checkout / Renewal Library (In List)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Checkout Date/Time (Transform to Date, change Operator to Between)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(and then maybe filters for shelving location and/or call number to focus on particular sections, depending on the size of the library)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Display: <o:p></o:p></p>
</div>
<p class="MsoNormal">(whichever display you fields you want here - I usually do owning library, shelving location, call number, title, author, barcode)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Circ ID (Transform to Count - this will total up the number of circs for each item).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I hope that helps,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Terran<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr style="height:123.0pt">
<td valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:123.0pt">
<p style="margin:0in"><span style="font-family:"Arial",sans-serif;color:black;border:none windowtext 1.0pt;padding:0in"><img border="0" width="75" height="75" style="width:.7812in;height:.7812in" id="_x0000_i1029" src="https://lh6.googleusercontent.com/fJoF6o0xl9XByQZmykva1sv2n_cKGUXL_BH4crkpJgSqDu-yU7-5jIypuXBsEuoXCCBAAUQ2jUztJlZDNUVOlwl1bWZIL1W4wmFuEEzCLVMxUyhzdkV7jkcRcdZZni2z8OPz4xJA"></span><o:p></o:p></p>
</td>
<td valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:123.0pt">
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<b><span style="font-family:"Verdana",sans-serif;color:#1E439B">Terran McCanna, PINES Program Manager</span></b><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<b><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1E439B">Georgia Public Library Service | University System of Georgia</span></b><o:p></o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1E439B">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</span><o:p></o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1E439B;background:white">(404) 235-7138</span><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1E439B"> |
<a href="mailto:tmccanna@georgialibraries.org" target="_blank">tmccanna@georgialibraries.org</a>
</span><o:p></o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1E439B"><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></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt">
<a href="https://www.facebook.com/georgialibraries" target="_blank"><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#1155CC;border:none windowtext 1.0pt;padding:0in;text-decoration:none"><img border="0" width="36" height="36" style="width:.375in;height:.375in" id="_x0000_i1028" src="https://lh4.googleusercontent.com/77DYzuoZ-zqC0pyQuYNKCrWaPuOANHsYTJze0JxE_iK4yW2sCswywdPCC8hCHOIyhO7KKIO-L6dlN1wIqdHFcyJmTa1fuc5Ok34dR8FQTtZHawpgNmovGxjg9RS0-WI74dFDHw0_"></span></a><a href="https://www.twitter.com/georgialibs" target="_blank"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1155CC;border:none windowtext 1.0pt;padding:0in;text-decoration:none"><img border="0" width="35" height="35" style="width:.3645in;height:.3645in" id="_x0000_i1027" src="https://lh4.googleusercontent.com/1bKX66xWgHe-v5FD5l-hYX4FrZDXi1Y2aKr0DZLDA_oEHy7s01WVqgVilQcwGBzRQZAg3yOePmZncGwtiYGSgavOkb0T5Tj3c46iUJ7ZE7h-MUEhVwXQs7Oc3cahIYMN2SGlk_6b"></span></a><a href="https://www.instagram.com/georgialibraries/" target="_blank"><b><span style="font-family:"Verdana",sans-serif;color:#1155CC;border:none windowtext 1.0pt;padding:0in;text-decoration:none"><img border="0" width="34" height="34" style="width:.3541in;height:.3541in" id="_x0000_i1026" src="https://lh3.googleusercontent.com/U7PH5YIQnuRvbeMnGOlJAEPAre7Zqx_I6IDJAtJVwUDCp1-TmjSwP_x21qKx8ApsbcaILIuSpL3Pzau2Rz-phR_4IPcLR4LrIha_JMDHqombNtsfa1uhXcYS02QWTAyYqSf3ES_n"></span></b></a><o:p></o:p></p>
</td>
</tr>
<tr style="height:21.0pt">
<td colspan="2" valign="top" style="padding:5.0pt 5.0pt 5.0pt 5.0pt;height:21.0pt">
<p align="center" style="margin:0in;text-align:center"><a href="http://georgialibraries.org" target="_blank"><i><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1155CC;background:white">Join our email list</span></i></a><i><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:black;background:white">
</span></i><i><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#434343;background:white">for stories of Georgia libraries making an impact in our communities.</span></i><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, Jan 27, 2022 at 3:05 PM Deanna Frazee via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org" target="_blank">evergreen-general@list.evergreen-ils.org</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Bahnschrift SemiBold Condensed",sans-serif;color:#1F497D">Deanna Frazee</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">Director of Library Services</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">Killeen Public Library</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">City of Killeen, Texas</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">254-501-8995 (office)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">254-501-7704 (fax)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D"><a href="mailto:http://dfrazee@killeentexas.gov" target="_blank">dfrazee@killeentexas.gov</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D"><a href="http://www.killeentexas.gov/" target="_blank">www.killeentexas.gov</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi, Adam,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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?<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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? <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks!<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Deanna<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:14.0pt;font-family:"Bahnschrift SemiBold Condensed",sans-serif;color:#1F497D">Deanna Frazee</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">Director of Library Services</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">Killeen Public Library</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">City of Killeen, Texas</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">254-501-8995 (office)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D">254-501-7704 (fax)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D"><a href="mailto:http://dfrazee@killeentexas.gov" target="_blank">dfrazee@killeentexas.gov</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;color:#1F497D"><a href="http://www.killeentexas.gov/" target="_blank">www.killeentexas.gov</a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><o:p></o:p></p>
</blockquote>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>