[Wactclc-alma] Analytics - Report for identifying titles that have more than one holding

[Yasuda, Naoko]

Hi Greg,

In your current report, how about adding Physical Item Details>Num of Items (In Repository) and filter by "is greater than  1"? You could also add Location>Location Name to see if multiple copies are in different locations.

Naoko
Highline College
________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> on behalf of Bem, Greg <Greg.Bem at lwtech.edu>
Sent: Tuesday, May 12, 2020 10:03 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Analytics - Report for identifying titles that have more than one holding

CAUTION: This email originated from outside Highline College. Do not click links or open attachments unless you validate the sender and know the content is safe. If you are unsure, contact the Help Desk at x4357 (206-592-4357) or email helpdesk at highline.edu.

Hey all,



For the Analytics gurus on the list, I’m curious if anyone is aware of a way to pull a report that displays a list of titles that have more than 1 copy. Titles could multiple editions—just looking for anything that has the same name. It would be great to have a list of every single title without every copy (to reduce the size of the spreadsheet), but if that’s not possible that’s okay.



Some context: we’re doing our annual weeding soon, and want to start our review with potentially removing extraneous copies of books, rather than all instances of a particular title. Our current weeding review list (attached), while not huge, would require a bunch of manual deletion within the spreadsheet to see those multi-copy titles, and if we start to create larger reports, I don’t want to have to rely on said manual deletion.



Thanks!



Greg



Greg Bem, MLIS

Faculty Library Coordinator

Library Learning Commons

Lake Washington Inst. Of Technology

Pronouns: he/him/his



Vice President, AFT 3533, ’19-‘20



Contact Info

greg.bem at lwtech.edu<mailto:greg.bem at lwtech.edu%0d>

425-739-8100 xt.8898

http://www.lwtech.edu/campus-life/library



Chat with me on Microsoft Teams<https://teams.microsoft.com/>, or

Chat with librarians 24/7 on Ask a Librarian<https://www.questionpoint.org/crs/servlet/org.oclc.admin.BuildForm?&page=accessable&institution=13155&type=2&language=1>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200513/3c17a6de/attachment-0002.html>