Statistics for Shelving Location and Collection Code
Does anyone know if you can circulation statistics for Shelving Location and Collection code by location? In Koha we may need to use a combination of these two codes for display purposes. This will make it difficult to get statistics since there could be many different combinations created in the item database. In Dynix the display function and statistical function are separated. -- Vicki Teal Lovely vtl@scls.lib.wi.us Software Applications Supervisor SCLS Automation 201 W. Mifflin St. Madison, WI 53703 (608)261-9109
I'm sure it can be done. I did this one with item type and shelving location - we can probably just change item type to collection code. #Answers - how many new books added at each library sorted by shelving location and item type: SELECT count(i.biblionumber) as added, i.itype, i.homebranch, i.location from items i WHERE YEAR(i.dateaccessioned) = 2008 AND MONTH(i.dateaccessioned) = 10 GROUP BY i.homebranch,i.itype,i.location ORDER BY i.homebranch,i.itype,i.location asc If I get some time I can try to tweak - if not - then someone else can try to tweak it :) --- 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 Tue, May 26, 2009 at 5:41 PM, Vicki Teal Lovely <vtl@scls.lib.wi.us> wrote:
Does anyone know if you can circulation statistics for Shelving Location and Collection code by location? In Koha we may need to use a combination of these two codes for display purposes. This will make it difficult to get statistics since there could be many different combinations created in the item database.
In Dynix the display function and statistical function are separated.
-- Vicki Teal Lovely
vtl@scls.lib.wi.us
Software Applications Supervisor SCLS Automation 201 W. Mifflin St. Madison, WI 53703
(608)261-9109
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Vicki You might find this page helpful: http://www.nexpresslibrary.org/training/reports-training/ < you can copy/paste most of those statements into Koha. For ccode/shelving location, it's - just update the 04 to whatever month you want: SELECT count(i.biblionumber) as added, i.ccode, i.homebranch, i.location from items i WHERE YEAR(i.dateaccessioned) = 2009 AND MONTH(i.dateaccessioned) = 04 GROUP BY i.homebranch,i.ccode,i.location ORDER BY i.homebranch,i.ccode,i.location asc For the fancy video version of our suite of monthly stat reports...visit: http://www.nexpresslibrary.org/category/tutorial/ and scroll down until you get to the monthly circ videos. Long live Jing. Sharon Moreland NExpress Shared Catalog Northeast Kansas Library System On Tue, May 26, 2009 at 4:41 PM, Vicki Teal Lovely <vtl@scls.lib.wi.us>wrote:
Does anyone know if you can circulation statistics for Shelving Location and Collection code by location? In Koha we may need to use a combination of these two codes for display purposes. This will make it difficult to get statistics since there could be many different combinations created in the item database.
In Dynix the display function and statistical function are separated.
-- Vicki Teal Lovely
vtl@scls.lib.wi.us
Software Applications Supervisor SCLS Automation 201 W. Mifflin St. Madison, WI 53703
(608)261-9109
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Sharon Moreland Technology Consultant Northeast Kansas Library System
participants (3)
-
Nicole Engard -
Sharon Moreland -
Vicki Teal Lovely