[Evergreen-reports] Average Renewals used

[Elizabeth Davis]

Thanks John! This worked great as well.

[cid:image003.png at 01D99538.5079FF60]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

From: Evergreen-reports <evergreen-reports-bounces at list.evergreen-ils.org> On Behalf Of Galen Charlton via Evergreen-reports
Sent: Thursday, June 1, 2023 5:19 PM
To: John Amundson <jamundson at cwmars.org>
Cc: Galen Charlton <gmc at equinoxoli.org>; Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org>
Subject: Re: [Evergreen-reports] Average Renewals used

Hi,

On Thu, Jun 1, 2023 at 5:07 PM John Amundson <jamundson at cwmars.org<mailto:jamundson at cwmars.org>> wrote:
> Your response made me want to tackle this again though, and I put
>  together this query that averages the renewal count per initial
> checkout over a given time period using a recursive CTE:

Nice! (And I was fully expecting somebody to pipe up with a solution based on CTEs; only question was who 😀)

Regards,

Galen
--
Galen Charlton
Implementation and IT Manager
Equinox Open Library Initiative
gmc at equinoxOLI.org<mailto:gmc at equinoxOLI.org>
https://www.equinoxOLI.org
phone: 877-OPEN-ILS (673-6457)
direct: 770-709-5581
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230602/15847bf6/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10034 bytes
Desc: image001.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230602/15847bf6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5402 bytes
Desc: image003.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230602/15847bf6/attachment-0003.png>