Thank you for the explanation! Between your explanation and Beverly Church's I've managed to figure out the problem. The top report listed the checkouts by the home library of the patron, not the checkout library so that was part of the issue. The other is we do appear to be affected by the reporting bug as well. There are thousands of renewals that show as having no agency code so they weren't included in the second report totals.
Is there someplace else to get the renewal information? I would think issues.lastrenewdate and old_issues.lastrenewdate would get me some of them but not if the item had been renewed twice. Thanks! Cindy Owen Leonard wrote: >> We recently went live and I'm now trying to run the monthly statistics >> reports I've set up. One of the reports is to total the number of >> checkouts and renewals for the month listed by library and the other is >> the same total number of checkouts and renewals but listed by the >> borrower category code. >> > > In Koha there is a bug which causes renewals to be recorded in the > statistics table with no branch code. I don't know if PTFS's fork has > a fix for this, but it sounds like that is a likely cause. Pending a > solution I've been including a report of circulations with no branch > alongside the other branch stats. > > -- Owen > > -- Cindy Weber [email protected] System Support Specialist (608)242-4710 South Central Library System _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
