[Evergreen-reports] Circulation Report

[Chris Sharp]

Oh, sorry.

None = "do not allow nulls for this value either in the table I'm joining *from* or in the table I'm joining *to*" or "only bring back rows where both tables fully match" (which is the default JOIN when doing straight SQL).

----- Original Message -----
> From: "Chris Sharp" <csharp at georgialibraries.org>
> To: "Evergreen Community Reports Email List" <evergreen-reports at list.evergreen-ils.org>
> Sent: Thursday, January 29, 2015 1:03:17 PM
> Subject: Re: [Evergreen-reports] Circulation Report
> 
> 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/
> 

-- 
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/