[Evergreen-reports] Circulation Report

[Tina Ji (Project Sitka)]

Hi Jessica,

I think if your start Source table is Item, all items should be  
included. It should be a default left join between Item and Circulation.

You may consider adding Checkout Date (transformed to Year) as a  
displayed field to group the checkout count by year. Use the Total  
Circulations table (linked from Item) to get the total circ count. You  
probably can get everything in one report. You may try it. :)

Tina Ji
BC Libraries Coop





Quoting Jessica Venturo <jventuro at biblio.org>:

> 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


Tina Ji
1-888-848-9250
Support Specialist
BC Libraries Cooperative/Sitka