[Wactclc-alma] deduping in analytics

Tue Feb 19 15:03:32 PST 2019

Here is a link for how to do row counts in analytics:

https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/How_do_I_display_the_total_number_of_rows_in_an_Analytics_report%3F

Only steps 1 and 2 are required.  If you don't want a whole column with the same number that's what steps 3 through 6 are for.

If you want the number of rows to show only once, at the top of your report, drag it from "Columns and Measures" and drop it in "Sections".
Be sure to use custom headings to rename the results.

[cid:image005.png at 01D4C864.462EE430]

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Paula Laine
Sent: Tuesday, February 19, 2019 10:01 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] deduping in analytics

I think I've figured this out.  The row count is what's important here.
My total number of discrete e-titles is 185,294. When I add the Material type filter I can break it down into books, journals, visual materials, and maps.

[cid:image003.png at 01D4C839.127781E0]

[cid:image004.png at 01D4C839.127781E0]

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Friday, February 15, 2019 3:00 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] deduping in analytics

Looking at results of my attempt, though, I don't think it's accurately counting titles with portfolios.

Same problem I ran into when I tried to do this before.

Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org&data=01%7C01%7Cplaine%40bellevuecollege.edu%7Ce1fb07170bc5452e20ef08d696945c71%7Cf94c251c1347422eb3ea8ac56befd6cb%7C1&sdata=5541ixZAkXOvdL%2FD228JLwuSCQZpq6kZ21FZPtt3BQA%3D&reserved=0>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Friday, February 15, 2019 2:32 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] deduping in analytics

ATTENTION: This email contains links. Please follow best practices before clicking on links
And I didn't add any date created filter to that one. So, you'd probably want to add a date filter of created before 7/1/2018

Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org&data=01%7C01%7Cplaine%40bellevuecollege.edu%7Ce1fb07170bc5452e20ef08d696945c71%7Cf94c251c1347422eb3ea8ac56befd6cb%7C1&sdata=5541ixZAkXOvdL%2FD228JLwuSCQZpq6kZ21FZPtt3BQA%3D&reserved=0>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Friday, February 15, 2019 2:28 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] deduping in analytics

ATTENTION: This email contains links. Please follow best practices before clicking on links
You can try this in the titles subject area:

[cid:image006.png at 01D4C839.127781E0]

Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org&data=01%7C01%7Cplaine%40bellevuecollege.edu%7Ce1fb07170bc5452e20ef08d696945c71%7Cf94c251c1347422eb3ea8ac56befd6cb%7C1&sdata=5541ixZAkXOvdL%2FD228JLwuSCQZpq6kZ21FZPtt3BQA%3D&reserved=0>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Herman, Amy
Sent: Friday, February 15, 2019 1:19 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] deduping in analytics

I am working on various numbers for ACRL and IPEDS. Is there an easy way to dedup portfolios across collections?

Thanks,

Amy Herman
Library Faculty | Olympic College
1600 Chester Avenue | Bremerton, WA 98337
aherman at olympic.edu<mailto:aherman at olympic.edu> | 360-475-7256

[alma signature]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 22262 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 14980 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 75016 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 6652 bytes
Desc: image004.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 62734 bytes
Desc: image005.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190219/2be94ad1/attachment-0014.png>