Josh- I tried this on Great Bend Public Library's collection and have a few observations. If the to/from date is the same (12/08 - 12/08), the result is zero. So I tried 12/08 - 12/09 and then got a figure. Kathy At 02:47 AM 12/6/2008, Joshua Ferraro wrote:
Hi Katharine,
On Fri, Dec 5, 2008 at 6:22 PM, Katharine Dixon <katharin@ci.salinas.ca.us> wrote:
Hello, I am new to the list so sorry if this has been asked before but does anybody have the SQL for a report that would just give me a total of all items circulated on a certain day. Just the number, no titles or types. You can find this out from the Circulation Statistics wizard, located in the Reports area. The path is /cgi-bin/koha/reports/issues_stats.pl
Select Period as a row, and specify the dates in question as From/To.
Select Library as a Column
Run the report and you will get a chart of circulations per branch for that date range.
Cheers,
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Kathy Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530 (620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax kdr@ckls.org ******************************************************************************************** I'm currently reading: Redesigning the American Lawn, by F. Herbert Bormann [... et al.] I'm currently listening to: Xenocide, by Orson Scott Card.