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

[Bem, Greg]

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/20200512/7dbb1fa4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: WEEDING REPORT SUMMER 2020 - 2010 Items Only.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 70195 bytes
Desc: WEEDING REPORT SUMMER 2020 - 2010 Items Only.xlsx
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200512/7dbb1fa4/attachment.xlsx>