[Koha] Report of Active Users for a Month

[Nicole Engard]

Woo Hoo :) My nagging has paid off :)

Nicole

2009/11/3 Melanie Hedgespeth <melanie at salpublib.org>

>  Added this to the KOHA reports wiki.
>
>
>
>
>
> Melanie
>
>  [image: facebook_email]<http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/91712193139?ref=s>
>
>
>
> *From:* koha-bounces at lists.katipo.co.nz [mailto:
> koha-bounces at lists.katipo.co.nz] *On Behalf Of *Melanie Hedgespeth
> *Sent:* Tuesday, November 03, 2009 1:50 PM
> *To:* Jesse
>
> *Cc:* koha at lists.katipo.co.nz
> *Subject:* Re: [Koha] Report of Active Users for a Month
>
>
>
> Thanks.  I realized I wasn’t seeing all the results.
>
>
>
> On screen, I wasn’t getting the full list.  Once I downloaded it then I saw
> the rest!
>
>
>
> Thanks.
>
>
>
> Melanie
>
> [image: facebook_email]<http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/91712193139?ref=s>
>
>
>
> *From:* Jesse [mailto:pianohacker at gmail.com]
> *Sent:* Tuesday, November 03, 2009 1:43 PM
> *To:* Melanie Hedgespeth
> *Cc:* koha at lists.katipo.co.nz
> *Subject:* Re: [Koha] Report of Active Users for a Month
>
>
>
>
>
> 2009/11/3 Melanie Hedgespeth <melanie at salpublib.org>
>
> Thanks.
>
> Does issue date refer to the date the item was checked out?
>
>
>
> I’m getting just a handful of issues so I’m off somewhere on it.
>
>
>
> Thanks.
>
>
>
> Melanie
>
> [image: facebook_email]<http://www.facebook.com/pages/Salina-KS/Salina-Public-Library/91712193139?ref=s>
>
>
>
> *From:* Jesse [mailto:pianohacker at gmail.com]
> *Sent:* Tuesday, November 03, 2009 1:20 PM
> *To:* Melanie Hedgespeth
> *Cc:* koha at lists.katipo.co.nz
> *Subject:* Re: [Koha] Report of Active Users for a Month
>
>
>
>
>
> 2009/11/3 Melanie Hedgespeth <melanie at salpublib.org>
>
> I am trying to create a report for active patrons within a specific month,
> divided up by patron category.
>
>
>
> (I see you can create a patron statistics report for patron activity within
> “years”, but can’t get the code so I can adjust it to a month’s period.)
>
>
>
> Any tips?
>
>
>
> Thanks!
>
>
>
> *Melanie Hedgespeth*
>
> Tech Center Manager
>
> Salina Public Library
>
> 785.825.4624 Ext. 233
>
> melanie at salpublib.org
>
>
>
>
> I assume by "active", you mean "checked out books", right? If so, you'd
> want something like this:
>
> SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT
> borrowernumber) FROM old_issues LEFT JOIN borrowers USING (borrowernumber)
> GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode;
>
> Because it uses old_issues, it won't include anything that's still checked
> out; getting around that requires either ugly subqueries or running the
> report with old_issues and issues and manually combining the results.
>
> --
> Jesse Weaver
>
> issuedate is the date the item was checked out, yes.
>
> A quick run of the SQL seemed to work on my library's data, but the use of
> issuedate does mean that it won't include any data migrated from Koha 2.2;
> it'll only include checkouts made under Koha 3.0.
>
> Substituting issuedate for date_due or returndate will include results from
> Koha 2.2, but will skew the results (as these refer to the due date and date
> the item was returned, respectively).
>
> --
> Jesse Weaver
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091103/450b9b1b/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 2556 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20091103/450b9b1b/attachment.gif