[OPEN-ILS-GENERAL] what data do I pull from for a circ by subject report

[Walz, Jennifer]

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
jlwalz at asbury.edu

From: Open-ils-general [mailto:open-ils-general-bounces at 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.hamby at yclibrary.net<mailto:rogan.hamby at 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 <jlwalz at asbury.edu<mailto:jlwalz at 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<tel:859-858-3511%20ext.%202269>
jlwalz at asbury.edu<mailto:jlwalz at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150720/3671bbbd/attachment-0001.html>