[Evergreen-reports] Circulation Report

Thu Jan 29 17:38:52 EST 2015

Really, all joins are much easier to understand in practice than it is to
explain them.  :)

On Thu, Jan 29, 2015 at 1:07 PM, Chris Sharp <csharp at georgialibraries.org>
wrote:

> 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/
> _______________________________________________
> 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/20150129/2ca9f61a/attachment-0001.html>