[Evergreen-reports] Circulation Report

[Chris Sharp]

Jessica,

For Nullability Selection, here's the key:

The table you're joining *from* is always on the "left" and the table you're joining *to* is always on the "right".

Child = "the table I'm joining *to* can have a null value in this field"  (equivalent of a RIGHT JOIN)
Parent = "the table I'm joining *from* can have a null value in this field" or "bring back rows even if this field is null on the 'left' table" (equivalent of a LEFT JOIN)
Default = "do whichever join I would have done anyway" (which can still be a LEFT or RIGHT JOIN)

So if you have a specific field that requires nullability selection, you *probably* want Default when doing all of your other joins.  The way I think of it, I'm manually forcing this one table to join the way I want it to, but it's okay for all the other joins to work the way they normally do.

I hope that isn't too convoluted ;-).

Chris

----- Original Message -----
> From: "Jessica Venturo" <jventuro at biblio.org>
> To: "Evergreen Community Reports Email List" <evergreen-reports at list.evergreen-ils.org>
> Sent: Thursday, January 29, 2015 12:15:24 PM
> Subject: Re: [Evergreen-reports] Circulation Report
> 
> 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
> 
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
> 

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/