Last week I updated this document: http://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Rep... to include a tip about dates. "TIP: The statistic reports are exclusive, so, if you want a report to show data for the month of November you should pick October 31 to December 1." So if you want the month of December you should do December 1 to January 1. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Mon, Dec 8, 2008 at 7:36 PM, Kathy Rippel <kdr@ckls.org> wrote:
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.
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha