Re: [OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report
Hi Jennifer, Ok. So what is the difference between Aged and Active? And why are not all circs just circs? If the item ever went out, isn’t it counted as having circulated? Aged circs are ones where the user data is disassociated with the circulation, but statistical data about what, where, and when are preserved in a table outside the normal circulation table. At this point, yes, all circulation counts for items within the Evergreen application (Item Status, Last Few Circulations, etc.) should count both aged and active circulations. Any further advice on this report is welcome. I have not really started working with it yet except to look at what Rogan suggested. My source was “Circulation” from the drop down list of Sources. My base filters were:Check out Date / Time (selecting between year+month) and Org ID Still not sure how to select call number range, but was going with Item – Call # / Vol – Call# label and choosing “between” My displayed fields so far are: Circ Library, Circ count, and Call number Label. I would really like to get the call number “group” rather than exact call numbers. Anyone have any ideas about that? In other words, if an item has a call number of 365.4988 F45c it would fall in the 300’s group. My idea is to use the “between” transform and run a report for each call number 100’s range. If there are other options, I’d like to know. It would be great to get an aggregate TOTAL of all items that circulated within the 300’s for the current date range (i.e. year). You might try out the Classic Circulation View source, which is visible from within the reports interface, but not enabled on the backend by default. See https://bugs.launchpad.net/evergreen/+bug/1050384 for discussion about why not. In any case, that view has Dewey Hundreds and Dewey Tens as available columns, and might do exactly what you want. And, yes, it counts both aged and active circs. Hopefully that helps some! Chris -- Chris Sharp PINES System Administrator Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/
Re: [OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report
I haven't created this report template, but I think that Rogan's suggestion is correct. One thing to keep in mind is that there are a few different circulations sources. If you would like to include aged circulations, you should choose the Combined Aged and Active Circulations source. beth On Tue, Jul 14, 2015 at 4:01 PM, Rogan Hamby rogan.ha...@yclibrary.net wrote: Renewals are circs so that shouldn't be an issue. If I'm understanding what you're looking for correctly you're going to want to connect from the circulation data source to the copy and from there to the call number and the call number label will have your dewey call numbers. I don't think you'll need to pull from the MARC for this. On Tue, Jul 14, 2015 at 3:58 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – I need help from the Evergreen Wisdom. My boss wants “count circs by subject -- in our case, Dewey class.”I am pretty good so far at working with the templates and even creating a completely new report. Problem is, I am not sure what data source to pull from.And will I have to be selecting something from the marc fields? I am pretty dumb on that part.Anyone already done something like this that could give me a few pointers in the right direction? (I figure other parameters are going to be by date and by library. Are renewals counted as circs?) Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS data reporting Kinlaw Library - *Asbury University* One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis -- Beth Willis Digital Catalog Librarian NOBLE, Inc. 26 Cherry Hill Drive Danvers, MA 01923
Re: [OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report
All – Ok. So what is the difference between Aged and Active? And why are not all circs just circs? If the item ever went out, isn’t it counted as having circulated? Any further advice on this report is welcome. I have not really started working with it yet except to look at what Rogan suggested. My source was “Circulation” from the drop down list of Sources. My base filters were:Check out Date / Time (selecting between year+month) and Org ID Still not sure how to select call number range, but was going with Item – Call # / Vol – Call# label and choosing “between” My displayed fields so far are: Circ Library, Circ count, and Call number Label. I would really like to get the call number “group” rather than exact call numbers. Anyone have any ideas about that? In other words, if an item has a call number of 365.4988 F45c it would fall in the 300’s group. My idea is to use the “between” transform and run a report for each call number 100’s range. If there are other options, I’d like to know. It would be great to get an aggregate TOTAL of all items that circulated within the 300’s for the current date range (i.e. year). Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS reports madness Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Beth Willis Sent: Monday, July 20, 2015 2:19 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report I haven't created this report template, but I think that Rogan's suggestion is correct. One thing to keep in mind is that there are a few different circulations sources. If you would like to include aged circulations, you should choose the Combined Aged and Active Circulations source. beth On Tue, Jul 14, 2015 at 4:01 PM, Rogan Hamby rogan.ha...@yclibrary.netmailto:rogan.ha...@yclibrary.net wrote: Renewals are circs so that shouldn't be an issue. If I'm understanding what you're looking for correctly you're going to want to connect from the circulation data source to the copy and from there to the call number and the call number label will have your dewey call numbers. I don't think you'll need to pull from the MARC for this. On Tue, Jul 14, 2015 at 3:58 PM, Walz, Jennifer jlw...@asbury.edumailto:jlw...@asbury.edu wrote: All – I need help from the Evergreen Wisdom. My boss wants “count circs by subject -- in our case, Dewey class.”I am pretty good so far at working with the templates and even creating a completely new report. Problem is, I am not sure what data source to pull from.And will I have to be selecting something from the marc fields? I am pretty dumb on that part.Anyone already done something like this that could give me a few pointers in the right direction? (I figure other parameters are going to be by date and by library. Are renewals counted as circs?) Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS data reporting Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269tel:859-858-3511%20ext.%202269 jlw...@asbury.edumailto:jlw...@asbury.edu -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewishttp://www.goodreads.com/author/show/1069006.C_S_Lewis -- Beth Willis Digital Catalog Librarian NOBLE, Inc. 26 Cherry Hill Drive Danvers, MA 01923
Re: [OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report
Renewals are circs so that shouldn't be an issue. If I'm understanding what you're looking for correctly you're going to want to connect from the circulation data source to the copy and from there to the call number and the call number label will have your dewey call numbers. I don't think you'll need to pull from the MARC for this. On Tue, Jul 14, 2015 at 3:58 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – I need help from the Evergreen Wisdom. My boss wants “count circs by subject -- in our case, Dewey class.” I am pretty good so far at working with the templates and even creating a completely new report. Problem is, I am not sure what data source to pull from.And will I have to be selecting something from the marc fields? I am pretty dumb on that part.Anyone already done something like this that could give me a few pointers in the right direction? (I figure other parameters are going to be by date and by library. Are renewals counted as circs?) Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS data reporting Kinlaw Library - *Asbury University* One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis
[OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report
All - I need help from the Evergreen Wisdom. My boss wants count circs by subject -- in our case, Dewey class.I am pretty good so far at working with the templates and even creating a completely new report. Problem is, I am not sure what data source to pull from.And will I have to be selecting something from the marc fields? I am pretty dumb on that part.Anyone already done something like this that could give me a few pointers in the right direction? (I figure other parameters are going to be by date and by library. Are renewals counted as circs?) Thanks! Jennifer -- Jennifer Walz, MLS - Head of ILS data reporting Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu