[Evergreen-reports] Circulation Report
Lynn Floyd
lfloyd at andersonlibrary.org
Thu Jan 29 13:35:07 EST 2015
+1
Lynn Floyd
lfloyd at andersonlibrary.org
Anderson County Library
Sent from my Phone. Excuse my thumbs.
On Jan 29, 2015 1:24 PM, Geoff Sams <GSams at roanoketexas.com> wrote:
>
> I think this needs to be placed in documentation somewhere. This is the best description I've heard for nullability in general.
>
> You've made the world much clearer for me at least! Thanks for that.
>
> Thanks,
> Geoff Sams
> Library Manager
> Roanoke Public Library
>
> -----Original Message-----
> From: Evergreen-reports [mailto:evergreen-reports-bounces at list.evergreen-ils.org] On Behalf Of Chris Sharp
> Sent: Thursday, January 29, 2015 12:07 PM
> To: Evergreen Community Reports Email List
> Subject: Re: [Evergreen-reports] Circulation Report
>
> 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-rep
> > > orts
> > >
> > >
> > >
> > > _______________________________________________
> > > Evergreen-reports mailing list
> > > Evergreen-reports at list.evergreen-ils.org
> > > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-rep
> > > orts
> > >
> > >
> > >
> > >
> > > --
> > > 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-rep
> > > orts
> > >
> >
> > --
> > 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
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
More information about the Evergreen-reports
mailing list