[Evergreen-reports] Monthly Recurring Reports

[Patrick, Irene]

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.

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.

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.

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?

Thanks for any advice!

Irene Patrick
Electronic Resources Librarian
State Library of North Carolina
NC Department of Natural and Cultural Resources
919.814.6788 |  irene.patrick at ncdcr.gov<mailto:irene.patrick at ncdcr.gov>

109 East Jones Street  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
[A close up of a logo  Description automatically generated]<https://statelibrary.ncdcr.gov/>
Twitter<https://twitter.com/ForEverythingNC> | Facebook<https://www.facebook.com/ncghl/> | Instagram<https://www.instagram.com/foreverythingnc/> | YouTube<https://www.youtube.com/user/statelibrarync/> | LinkedIn<https://www.linkedin.com/company/state-library-of-north-carolina>
Don’t wait to vaccinate. Find a COVID-19 vaccine location near you at MySpot.nc.gov<https://covid19.ncdhhs.gov/vaccines>.
Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220323/41044f0d/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 49715 bytes
Desc: image001.jpg
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220323/41044f0d/attachment-0001.jpg>