[Evergreen-reports] Circulation Report

[Jessica Venturo]

Hi Tina and Cristina,

Thanks for responding and sorry that it took me a little while to get back
to you! I appreciate your help.

Tina - I have been starting from the Item source. I did try transforming
the checkout date to year. I sent the report to the librarian for review,
and he said it didn't help him because each item is listed muliple times
for each year that it circed. This makes it difficult to compare data for
all items. I tried fiddling with Excel Pivot tables to get the display that
he wanted (the years as columns), but I couldn't make it work. If anybody
has ideas about how to manipulate the data in Excel, I would love that!

Cristina - I thought I would not need to use the nullabilty feature because
a left outer join is already being done on circulation table from the Item
source. However, I will admit that I am no expert in using the feature.
When I check off "Enable nullability selection," I get the following
options for the circulation table: None, Child, and Default. I would think
selecting default would get me the desired results, but it doesn't seem to.
Am I wrong on that?

Thanks again for your help!
Jessica

On Sat, Jan 24, 2015 at 9:52 PM, Cristina Hernandez Trotter <
chtrotter at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
>


-- 
Jessica Venturo
Applications Support Specialist
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 x105
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20150129/f9b98a88/attachment.html>