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

Wed May 13 13:28:01 PDT 2020

Seconding Colleen's suggestion.

There's also a webinar that Yoel did sometime within the last year where he talks about a canned Alma report that Ex Libris set up to look for overlap between print books and ebooks.  The webinar I attended may have been more or less the same as the one Colleen mentioned.

In the webinar I attended, Yoel talked about a formula Ex Libris uses where they combine a set number of letters from the title plus a set number of letters from the author.  Yoel says that, in general, they've found that if this combination of letters from one title matches the combination of letters from another title, it's pretty likely that both titles are the same.

Check out the canned report:
               /shared/Alma/Titles/Reports/Overlap P and P

The Overlap By column has the formula that combines title and author.

Bear in mind that the more editions a book has, the greater the chance that the title will have changed or that the authors will have changed.  There's not going to be an easy way in Analytics to identify all the editions in your collection if the authors or title have changed between editions.

The Overlap report should at least get you started.

It will be ok!

Kirsti S. Thomas
Library Technical Service Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of McGaughey, Colleen
Sent: Wednesday, May 13, 2020 12:28
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

Maybe you could just use the Physical Item Usage for Weeding Report. It could probably be edited to display if there are multiple holding at your location or in storage (if you have a storage location). I have put a screenshot below to show you what fields is covered in this report. I had it set to display items that have not circulated in 5 years or more. There is a good webinar that discuss this topic during the Knowledge Days event. I believe it was called Using ALMA Analytics for Overlap and Deselection.

[cid:image002.png at 01D62926.309D7590]

Hope this helps.

Colleen McGaughey
Clover Park Technical College.
________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of Guidry, Wade <WadeG at bigbend.edu<mailto:WadeG at bigbend.edu>>
Sent: Wednesday, May 13, 2020 10:58 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Analytics - Report for identifying titles that have more than one holding

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:image003.png at 01D62926.309D7590]

Wade Guidry

WACTCLC

Library Consortium Services Manager

wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

http://www.wactclc.org<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=02%7C01%7C%7C614099dcea2d4ca159cd08d7f773d79e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637249949223979648&sdata=2X5UX9L7mg80f0GAefLIxJUH4Y2EJ8NhfWkjWzCCkyo%3D&reserved=0>

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<mailto: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<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.lwtech.edu%2Fcampus-life%2Flibrary&data=02%7C01%7C%7C614099dcea2d4ca159cd08d7f773d79e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637249949223989640&sdata=hqPF8oXzar8DTOAiCb6HEahcrLVZjfqqq71XWUIDi0Y%3D&reserved=0>

Chat with me on Microsoft Teams<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fteams.microsoft.com%2F&data=02%7C01%7C%7C614099dcea2d4ca159cd08d7f773d79e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637249949223989640&sdata=l75SXn2dUY%2BBaNIIsHQs%2F26kpPjgtb4ZISPTihE5xqo%3D&reserved=0>, or

Chat with librarians 24/7 on Ask a Librarian<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.questionpoint.org%2Fcrs%2Fservlet%2Forg.oclc.admin.BuildForm%3F%26page%3Daccessable%26institution%3D13155%26type%3D2%26language%3D1&data=02%7C01%7C%7C614099dcea2d4ca159cd08d7f773d79e%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637249949223999638&sdata=1xn7sleMmfLND4FNM7QEspjkwWnqUfTdGhDMMu7AGdM%3D&reserved=0>

CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200513/86481afa/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 65103 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200513/86481afa/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 56771 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200513/86481afa/attachment-0005.png>