<div dir="ltr"><div>Hi Blake,</div><div><br></div><div>I made the attached count report template. Could you use its criteria to get to an average?</div><div><br></div><div>Best,</div><div>Allison<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 16, 2024 at 11:29 AM Carol Witt via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@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 dir="ltr">Hi Blake,<div><br></div><div>Could you pull it from the 008 field? You'd want to use 008/07-10 (Dates: Date 1), and 008/011-14 (Dates: Date 2) if you wanted both.</div><div><br></div><div>Take care,</div><div><br></div><div>Carol</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 16, 2024 at 11:23 AM Blake Graham-Henderson via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org" target="_blank">evergreen-reports@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">Hello all,<br>
<br>
We're wrestling with the idea of reporting the average publication year <br>
for a set of items on certain shelves. As we all know, the publication <br>
year comes out of the MARC, and includes lots of non-digit characters <br>
like copyright symbols, brackets, parenthesis, etc. So it would seem we <br>
can't use that for an average. What is everyone else doing for this? Or <br>
are you?<br>
<br>
-- <br>
-Blake-<br>
Conducting Magic<br>
Will consume any data format<br>
MOBIUS<br>
<br>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><span><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:medium;border-collapse:collapse;table-layout:fixed;width:468pt"><colgroup><col><col width="492"></colgroup><tbody><tr style="height:0pt"><td style="border-width:1pt 1.5pt 1pt 1pt;border-style:solid;border-color:rgb(255,255,255) rgb(22,65,111) rgb(255,255,255) rgb(255,255,255);vertical-align:top;overflow:hidden"><br><span style="border:medium;display:inline-block;overflow:hidden;width:139px;height:95px"><img src="https://lh7-us.googleusercontent.com/BTeYvD845QYnbO00n7bcW0mkegZXE2em5ARs9Wf2nWywbVWwERY-OX2hNhHa5Q2bUtHqfHmJqPsAmqE27SIVQB1EylOXG6umU4lTi_eVtiYgPCsvPRceJaJ5NIfnQt0g1zNfQ9Xzx1BQb4IXQfBr_h8" width="139" height="95" style="margin-left: 0px; margin-top: 0px;"></span></td><td style="border-width:1pt 1pt 1pt 1.5pt;border-style:solid;border-color:rgb(255,255,255) rgb(255,255,255) rgb(255,255,255) rgb(22,65,111);vertical-align:top;padding:12.168pt;overflow:hidden"><p dir="ltr" style="line-height:1.62;margin-top:0pt;margin-bottom:0pt"><span style="font-size:12pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;font-weight:700;vertical-align:baseline">Carol Witt</span><span style="font-size:13.5pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;font-weight:700;vertical-align:baseline"> </span><span style="font-size:10pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;vertical-align:baseline">(she/her)</span><span style="font-size:13.5pt;font-family:"Lucida Sans",sans-serif;color:rgb(22,65,111);background-color:transparent;vertical-align:baseline"><br></span><span style="font-size:10pt;font-family:"Lucida Sans",sans-serif;color:rgb(33,33,33);background-color:transparent;vertical-align:baseline">Bibliographic Services Supervisor, C/W MARS, Inc.</span></p><p dir="ltr" style="line-height:1.62;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:0.891;margin:1pt"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline"><span style="border:medium;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/q2gbyNougapcDYhTiiAoMKelbfwl4oBcCuMyNmB7_bZgeRWYtCUSnQrPi8ab68yROW1C6B8se31KU4wjTYdlzuinue7h_Xi97ZJu6C6xr3EqCqgVazE_rD3pp-MYKD5TJaW_8Sso8VUemhZ3ZgWVK-k" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline"> </span><a href="mailto:wittc@cwmars.org" target="_blank"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(17,85,204);background-color:transparent;vertical-align:baseline">wittc@cwmars.org</span></a><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"> | </span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"><span style="border:medium;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/GPO7gOK3AuNSm_waxnVGOu-PeKE-f640ESs-EXBt-eXrjP9hB2u1wmYQTJpmJLFLftYqtpCw8ltF6CBPooVqCLY5dgi3VYt9icN3ee_C9lFkhUm82tiw5ko3bHcS2TG__DE16fQw4l1VbUVjSZi7eMY" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><a href="https://www.cwmars.org/" target="_blank"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(33,33,33);background-color:transparent;vertical-align:baseline">www.cwmars.org</span></a></p><p dir="ltr" style="line-height:0.891;margin:10pt 1pt 1pt"><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"><span style="border:medium;display:inline-block;overflow:hidden;width:20px;height:20px"><img alt="icon" src="https://lh7-us.googleusercontent.com/WVVHVDQPC1RdxWy1cXUgwZCioM6tDySYHtda3ZPPSC8CP1-_gc-0vQDpWNAIRX21VJAyP2mwtUcnLjE7ULN1Mz1rI_j2TUYPQ2HmeK666QOf-U-J4jFv3-hyLjW-ztWd5_wmzoXXDmi7P3fBnbrFc44" width="20" height="20" style="margin-left: 0px; margin-top: 0px;"></span></span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;font-weight:700;vertical-align:baseline"> </span><span style="font-size:9pt;font-family:"Lucida Sans",sans-serif;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline">508-755-3323 x 3</span></p></td></tr></tbody></table></div></span></div></div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><font color="#000000">Allison Midgley</font><div><span style="background-color:rgb(255,255,255)"><font color="#000000">Senior Technology Training Coordinator</font><br></span></div><div><span style="background-color:rgb(255,255,255)"><font color="#000000">Westchester Library System</font></span></div><div><span style="background-color:rgb(255,255,255)"><font color="#000000">570 Taxter Road, Suite 400, Elmsford, NY 10523</font></span></div><div><a href="tel:914-231-3222" value="+19142313222" style="font-size:12.8px;color:rgb(17,85,204)" target="_blank">914-231-3221</a></div><div><a href="mailto:amidgley@wlsmail.org" target="_blank">amidgley@wlsmail.org</a><br></div><div><span style="color:rgb(34,34,34);font-family:Roboto,sans-serif;background-image:initial;background-position:initial;background-repeat:initial;border:0px;font-size:14px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;white-space:pre-wrap">Spread the word about our programs!  Let us know what you'd like from our</span><span style="color:rgb(34,34,34);font-family:Roboto,sans-serif;background-image:initial;background-position:initial;background-repeat:initial;border:0px;font-size:14px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;white-space:pre-wrap"> </span><span style="color:rgb(34,34,34);font-family:Roboto,sans-serif;font-size:14px;white-space:pre-wrap"><a href="https://www.firstfind.org/wp-content/uploads/2023/01/JANUARY-2023-PIE-Publications-Catalog-Current.pdf" style="color:rgb(17,85,204)" target="_blank">Outreach Publications Catalog</a></span><span style="color:rgb(34,34,34);font-family:Roboto,sans-serif;background-image:initial;background-position:initial;background-repeat:initial;border:0px;font-size:14px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;white-space:pre-wrap">.</span></div><div><span style="font-family:Calibri,sans-serif;font-weight:700;color:rgb(103,78,167);font-style:italic">Hey Westchester, let's talk!  Find out more at <a href="http://conversations.westchesterlibraries.org/" target="_blank">conversations.westchesterlibraries.org</a>.</span></div></div></div>