[Evergreen-reports] Circulation Report

[Cristina Hernandez Trotter]

Hi, Jessica,

Were you able to get the report yet? If not, I will be happy try my hand at
it early next week.  A couple of thoughts initially: 1) Nullability feature
will probably have to be turned on to get the items with 0 circs in the
past year (or previous year). 2) It should be easy to get the total circs
and another circ count that is based on time frame, but I don't *think*
getting the 3 circ numbers to appear all on one report will work in the
reports module.

Cristina

On Fri, Jan 16, 2015 at 3:20 PM, Jessica Venturo <jventuro at biblio.org>
wrote:

> Hi all,
>
> I am working with a librarian who is trying to run a collection analysis
> for his library. He wanted to filter by Copy Location and Owning Library
> and include the following columns in his report: Author, Title, Pub Year,
> Call Number, Status,Owning Library, Copy Location, Total Circs, Total Circs
> current year, Total Circs previous year. I can handle the filters and most
> of the rest of it, but the last 3 columns have me stumped!
>
> At first I thought I could use the pivot label column to display the
> circulation by year as columns in a report, but I quickly learned it was
> not meant to be used in this way. Next, I thought I could have him run
> three separate reports - one for that showed circ for the current year, one
> for the previous year, and one for total circs so that he could copy and
> paste columns into the same spreadsheet. However, I found that any items
> that had circulation outside of the entered date range did not show up in
> the report.
>
> I'm curious - has anyone been able to provide something like this for
> their libraries? Any ideas would be greatly appreciated!
>
> Thank you,
> Jessica
>
> --
> Jessica Venturo
> Applications Support Specialist
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> 203-577-4070 x105
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20150124/20ac7278/attachment.html>