<div dir="ltr">Hi Irene,<div><br></div><div>For a recurring report to run automatically on a monthly schedule, I do this:<div><br></div><div>Filters:</div><div>Choose a Date Transform of "Year + Month" for whatever date field you are using.</div><div>Change the Operator to be "Equals"</div><div><br></div><div>When you create the Report Definition, choose a "Relative Date" for the date field and choose "1 month ago"</div><div>When you schedule the report, schedule it to run on the first day of the month -- that way it looks backwards and collects data from the previous month.</div><div><br></div><div>I hope that helps! Just let me know if you have any questions.</div><div><br></div><div>Best,</div><div>Jennifer</div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><p style="margin-bottom:0.0001pt;line-height:normal;background-image:initial;background-position:initial;background-repeat:initial"><span style="font-size:10pt;color:rgb(136,136,136)">Jennifer
Weston, MLIS<span></span></span></p>
<span style="font-size:10pt;line-height:107%;font-family:Calibri,sans-serif;color:rgb(136,136,136)">Product and Education Specialist</span><div><span style="font-size:10pt;line-height:107%;font-family:Calibri,sans-serif;color:rgb(136,136,136)"><span style="font-size:10pt;line-height:107%">Equinox Open Library Initiative</span><br></span></div><div><span style="font-size:10pt;font-family:Calibri,sans-serif;color:rgb(17,85,204)"><a href="mailto:jennifer.weston@equinoxoli.org" target="_blank">jennifer.weston@equinoxOLI.org</a></span><br></div><div><span style="font-size:10pt;line-height:107%;font-family:Calibri,sans-serif;color:rgb(136,136,136)"><span style="font-size:10pt;line-height:107%"><span style="font-size:10pt;line-height:107%"><span style="font-size:10pt;line-height:107%"><u><span style="font-size:10pt;line-height:107%;color:rgb(17,85,204);background-image:initial;background-position:initial;background-repeat:initial"><span style="color:rgb(17,85,204)"><a href="https://equinoxOLI.org" target="_blank">https://equinoxOLI.org</a></span></span></u><br></span></span></span></span></div><div><span style="font-size:10pt;line-height:107%;font-family:Calibri,sans-serif;color:rgb(136,136,136)"><span style="font-size:10pt;line-height:107%"><span style="font-size:10pt;line-height:107%"><span style="font-size:10pt;line-height:107%">phone: 877-OPEN-ILS (673-6457)<u><span style="font-size:10pt;line-height:107%;color:rgb(17,85,204);background-image:initial;background-position:initial;background-repeat:initial"><br></span></u></span></span></span></span></div><div><font color="#888888" face="Calibri, sans-serif"><span style="font-size:13.3333px">direct: 770-709-5574</span></font></div></div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 23, 2022 at 11:08 AM Patrick, Irene 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 lang="EN-US" style="overflow-wrap: break-word;">
<div class="gmail-m_-4786919274278575130WordSection1">
<p class="MsoNormal">I run reports every month to pull statistics for the previous month. I have been running these reports manually, and I started looking into a way to set them up to run automatically. However, I haven’t come up with a solution yet.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">What I’ve been doing for my monthly reports is pulling the needed information manually, using the Date transform and the Between operator to specify the beginning and ending dates for the report. I was hoping I could find a way to set
up recurring reports to replace the manual reports. After checking with our consortium folks, the suggestion was to use Age as the transform. But Age appears to be defined as 30 days. When I tested a recurring report for December statistics using Age, I
set it to run in the wee hours of January 1, but the output missed activity that occurred on December 1. I tested a few more reports for February, but running those late in the day on Feb. 28 picked up activity in January.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">The other problem I see with using Age is that if there’s a problem and the automated reports fail to run at the specified time, when they do run, they’ll pull information for the wrong days.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I have not seen anything in the Evergreen documentation that specifically defines the Age transform, or that explains how to set up monthly reports that pull information for a specific month, no matter how many days are in the month. Do
any of you have monthly recurring reports working? If so, can you tell me how I should set them up?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks for any advice!<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><span style="font-size:12pt;font-family:Arial,sans-serif;color:black">Irene Patrick<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Electronic Resources Librarian<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">State Library of North Carolina<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">NC Department of Natural and Cultural Resources
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">919.814.6788 | </span><span style="font-size:10pt;font-family:Arial,sans-serif"><a href="mailto:irene.patrick@ncdcr.gov" target="_blank"><span style="color:rgb(5,99,193)">irene.patrick@ncdcr.gov</span></a><span style="color:black">
<u></u><u></u></span></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">109 East Jones Street | 4640 Mail Service Center
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Raleigh, North Carolina 27699-4600<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-top:6pt"><a href="https://statelibrary.ncdcr.gov/" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:windowtext;text-decoration:none"><img border="0" width="327" height="102" style="width: 3.4083in; height: 1.0666in;" id="gmail-m_-4786919274278575130Picture_x0020_1" src="cid:17fb75708444ce8e91" alt="A close up of a logo
Description automatically generated"></span></a><u></u><u></u></p>
<p class="MsoNormal" style="margin-right:0in;margin-bottom:6pt;margin-left:0in">
<a href="https://twitter.com/ForEverythingNC" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)">Twitter</span></a>
<span style="font-size:10pt;font-family:Arial,sans-serif">|</span> <a href="https://www.facebook.com/ncghl/" target="_blank">
<span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)">Facebook</span></a><span style="font-size:10pt;font-family:Arial,sans-serif"> | </span><a href="https://www.instagram.com/foreverythingnc/" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)">Instagram</span></a><span style="font-size:10pt;font-family:Arial,sans-serif"> |
</span><a href="https://www.youtube.com/user/statelibrarync/" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(5,99,193)">YouTube</span></a><span style="font-size:10pt;font-family:Arial,sans-serif"> |
<span style="color:rgb(46,116,181)"><a href="https://www.linkedin.com/company/state-library-of-north-carolina" target="_blank"><span style="color:rgb(46,116,181)">LinkedIn</span></a></span><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-right:0in;margin-bottom:6pt;margin-left:0in">
<b><span style="font-family:Arial,sans-serif;color:rgb(32,31,30);background:white">Don’t wait to vaccinate. Find a COVID-19 vaccine location near you at </span></b><span style="font-size:10pt;font-family:Arial,sans-serif"><a href="https://covid19.ncdhhs.gov/vaccines" target="_blank"><b><span style="font-size:11pt;background:white">MySpot.nc.gov</span></b></a></span><b><span style="font-family:Arial,sans-serif;color:rgb(32,31,30);background:white">.</span></b><u></u><u></u></p>
<p class="MsoNormal" style="margin-top:12pt"><i><span style="font-size:10pt;color:rgb(127,127,127)">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><i><span style="font-size:10pt;color:rgb(127,127,127)"><u></u><u></u></span></i></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</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>