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

[Guidry, Wade]

Good ideas, Naoko. Building on that, for what you want to do, I'd recommend using the Physical Items subject area, so you can get loan counts as well.

Here's an example of a simple analysis that will generate useful info.

You may also what to add item call number, for weeding convenience.

But, if you add call number, you will get multiple rows per title for those with multiple items, because the call numbers for each item will be different.

[cid:image001.png at 01D62915.5E4AF0F0]


Wade Guidry
WACTCLC
Library Consortium Services Manager
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
http://www.wactclc.org<http://www.wactclc.org/>
509.760.4474

Pronouns: he/him/his


From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Yasuda, Naoko
Sent: Wednesday, May 13, 2020 10:38 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Analytics - Report for identifying titles that have more than one holding

CAUTION: Originated outside our network. Do not click links or open attachments unless you validate the sender.


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<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of Bem, Greg <Greg.Bem at lwtech.edu<mailto:Greg.Bem at lwtech.edu>>
Sent: Tuesday, May 12, 2020 10:03 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto: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<mailto: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/ff76a36e/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 56771 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200513/ff76a36e/attachment-0002.png>