[Evergreen-reports] Holdings Report

[Tony Miller]

I would agree, filtering in Excel or Google sheets would be better able to
give you the results you need.

On Fri, Sep 8, 2023 at 1:03 PM Tiffany Little <tlittle at georgialibraries.org>
wrote:

> Hi Elizabeth,
>
> If I understand correctly, I would use filters in Excel/Sheets for this.
> If you wanted to see where A and B have holdings and C doesn't, filter A as
> value 1, filter B as value 1, and filter C as blank.
>
> Tiffany Little, PINES Bibliographic Projects Manager
>
> ------------------------------
>
> Georgia Public Library Service
>
> 2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341
>
> (404) 235-7161 | tlittle at georgialibraries.org
>
> Join our email list <http://georgialibraries.org/> for stories of Georgia
> libraries making an impact in our communities.
>
>
> On Fri, Sep 8, 2023 at 1:57 PM Elizabeth Davis via Evergreen-reports <
> evergreen-reports at list.evergreen-ils.org> wrote:
>
>> Hi Tony
>>
>>
>>
>> Sorry, let me see if I explain this better.   I need a list of TCNs where
>> library A and/or library B own a copy, but library C doesn’t.   Each
>> library is the owning library in the record.  I can filter by owning
>> library in the reporter, but I need instances where library C doesn’t also
>> own a copy.  I need to find the unique TCNS that only library A and/or B
>> own.  They are going to be looking at holds on these TCNs to see what areas
>> of the collection where Library C could improve.
>>
>>
>>
>> Here are some examples of instances where A or B own copies by not C.
>>
>> *TCN Value*
>>
>> *Library A*
>>
>> *Library B*
>>
>> *Library C*
>>
>> 32163
>>
>> 1
>>
>> 42065
>>
>> 1
>>
>> 45583
>>
>> 1
>>
>> 50211
>>
>> 1
>>
>> 53821
>>
>> 1
>>
>> 58558
>>
>> 1
>>
>> 1
>>
>> 59811
>>
>> 1
>>
>> 68190
>>
>> 1
>>
>> 76960
>>
>> 1
>>
>> 81830
>>
>> 1
>>
>> 85557
>>
>> 1
>>
>> 1
>>
>> 86275
>>
>> 1
>>
>>
>>
>> Does that make more sense? It’s a tricky one to put concisely.
>>
>> Elizabeth
>>
>>
>>
>>
>>
>> *Elizabeth Davis* (she/her), *Support & Project Management Specialist*
>>
>> *Pennsylvania Integrated Library System **(PaILS) | SPARK*
>>
>> (717) 256-1627 | elizabeth.davis at sparkpa.org
>> <katherine.dannehl at sparkpa.org>
>> support.sparkpa.org | support at sparkpa.org
>>
>>
>>
>> *From:* Tony Miller <tony at poplarbluff.org>
>> *Sent:* Friday, September 8, 2023 1:39 PM
>> *To:* Evergreen Community Reports Email List <
>> evergreen-reports at list.evergreen-ils.org>
>> *Cc:* Elizabeth Davis <elizabeth.davis at sparkpa.org>
>> *Subject:* Re: [Evergreen-reports] Holdings Report
>>
>>
>>
>> I am not sure exactly if this is what you mean. You can filter by owning
>> library if you just need from a certain library. Is the owning library on
>> the record branch specific? You may try filtering by circulating library if
>> not.
>>
>>
>>
>> On Fri, Sep 8, 2023 at 12:20 PM Elizabeth Davis via Evergreen-reports <
>> evergreen-reports at list.evergreen-ils.org> wrote:
>>
>> Hello
>>
>>
>>
>> I’m looking to run a report to for a list of TCNs for a library system
>> where 2 of the 3 libraries own copies, but the 3rd location doesn’t own
>> a copy.  I’m looking for TCNs where libraries A and B are the only
>> libraries that own copies.  I have list of TCNs and copy counts, but I’m
>> having a hard time filtering out instances where all three libraries own
>> copies or where library C and A or library C and B own copies.
>>
>>
>>
>> Has anyone done this type of report or any ideas on how I can filter in
>> either Excel/Sheets or using OpenRefine?
>>
>>
>>
>> Thanks!
>>
>>
>>
>> *Elizabeth Davis *(she/her), *Support & Project Management Specialist*
>>
>> *Pennsylvania Integrated Library System (PaILS) | SPARK*
>>
>> (717) 256-1627 | elizabeth.davis at sparkpa.org
>> <katherine.dannehl at sparkpa.org>
>> support.sparkpa.org | support at sparkpa.org
>>
>>
>>
>> _______________________________________________
>> Evergreen-reports mailing list
>> Evergreen-reports at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>>
>>
>>
>>
>> --
>>
>> Tony Miller
>>
>> *User Services Coordinator *
>>
>> [image: 01]
>>
>> 318 North Main Street | Poplar Bluff, MO 63901
>> (573) 686 – 8639
>>
>> *Website <https://poplarbluff.org/> | Newsletter
>> <https://poplarbluff.org/OTS.pdf> | Annual Report
>> <https://poplarbluff.org/annualreport.html> | Digital Library
>> <http://poplarbluff.org/downloads.html> *
>>
>>
>>
>> *​**​Promoting Libraries to Make Our Communities Stronger*
>>
>> Poplar Bluff Municipal Library District with its community partners
>> provides and promotes equal access to reading, information, cultural and
>> intellectual resources.
>> _______________________________________________
>> Evergreen-reports mailing list
>> Evergreen-reports at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>>
>

-- 
Tony Miller
*User Services Coordinator *
[image: 01]
318 North Main Street | Poplar Bluff, MO 63901
(573) 686 – 8639
Website <https://poplarbluff.org/> | Newsletter
<https://poplarbluff.org/OTS.pdf> | Annual Report
<https://poplarbluff.org/annualreport.html> | Digital Library
<http://poplarbluff.org/downloads.html>


*​**​Promoting Libraries to Make Our Communities Stronger*
Poplar Bluff Municipal Library District with its community partners
provides and promotes equal access to reading, information, cultural and
intellectual resources.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/dc7be98b/attachment-0001.htm>