[Wactclc-alma] Manipulating Data in Analytics Analyses

Mon Mar 11 14:35:56 PDT 2019

Nevermind.  I don't think the list is going to work anyway - at least as it is right now, because it's not picking up anyone that has only a fine attached to their name and nothing checked out.

It's only giving me those students who have a fine with something checked out.

I'm beyond frustrated right now, so never mind on the question because the list doesn't have what I thought it did when I first compared them.

4 lists in front of me and nothing that is exactly what I want.  Ugh.

Stephanie Levesen
Periodicals/ILLs/Circulation
Norwood Cole Library
Skagit Valley College
2405 E College Way
Mount Vernon, WA  98273

360-416-7659

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Stephanie Levesen
Sent: Monday, March 11, 2019 2:14 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Manipulating Data in Analytics Analyses

Hi,

I've spent pretty much all morning trying to figure this out, and I just can't seem to get it, no matter how many times I try the help (both through Oracle and Google) to get the steps.

Kim and I have created an analysis through Analytics that combines those students who have either a fine or an overdue/billed item associated with their record.  We have been working off of two lists, but we figured out how to combine them.  Great.  Yay. Took us two years, but we (and I should say Kim) finally figured out how to do it.  :)

What I'd like to do with the list though is figure out a way to combine the names into a single line and have the remaining amount they owe summed so I get the total amount, not the itemized amount.  Here's a screenshot ( and yes I know I shouldn't include names, so hopefully my attempt at covering up some of the data for privacy and showing just the first name stays when emailed)

[cid:image002.png at 01D4D817.BBA49580][cid:image003.jpg at 01D4D817.BBA49580]

As you can see from the screenshot, the first four lines on the list belong to only two names because these people have two items checked out, and in the remaining amount it shows the amount due for each item.

How do you combine the lines so the name of the patron is listed only once, and the remaining amount shows the total (so in Autumn's case it should be $75.99) owed for that person instead of the itemized total?  I've looked through the column properties option and the edit formula information while in the criteria tab.  I've gone through the online help available in Analytics, as well as did a google search to see if I could figure out how to do it.  Nothing is working.

The data is coming from the same subject area (fines and fees) so it's not because I'm trying to combine two subject areas, which we've tried for another purpose and that just turns out badly.

If you want to look at the analysis, I can move it to a new folder.  Right now it's in shared folders - Skagit valley college - circulation - block lists and called "combined overdue and fines list."

Anyway, if anyone knows if this is even possible and how to do it and can give me the step-by-step I will be forever grateful.  My brain hurts right now.

Thanks,
Stephanie

Stephanie Levesen
Periodicals/ILLs/Circulation
Norwood Cole Library
Skagit Valley College
2405 E College Way
Mount Vernon, WA  98273

360-416-7659

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Thursday, March 7, 2019 4:08 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] FW: EBSCO Subscription books in the ALMA CZ

Some of you may have already received this message in some form.

[Title: Big Bend Community College Logo]

Wade Guidry
Library Consortium Services Manager
Big Bend Community College
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

509.760.4474
www.bigbend.edu<http://www.bigbend.edu/>

Big Bend Community College * 7662 Chanute Street NE * Moses Lake, WA 98837-3299

WACTCLC Alma Instance: Alma NA02<http://status.exlibrisgroup.com/>
WACTCLC Primo Instance: Primo NA08<http://status.exlibrisgroup.com/>

From: George Dragich [mailto:gdragich at EBSCO.COM]
Sent: Thursday, March 7, 2019 4:00 PM
To: Guidry, Wade <WadeG at bigbend.edu<mailto:WadeG at bigbend.edu>>
Subject: EBSCO Subscription books in the ALMA CZ

ATTENTION: This email contains links. Please follow best practices before clicking on links
Good news for all the CTC schools using our subscription collections:

We are pleased to announce that EBSCO eBooks Subscriptions are now available for selection in Alma Community Zone! EBSCO & ExLibris have been working over the past few months to deliver up to date, and more importantly, accurate subscription collections to the Community Zone via a KBART feed. Customers can now select these collections with confidence and know they include all the eBooks in the subscription collection at that point in time, and the eBooks are available to their users. When subscription updates occur, it does take ExLibris up to two weeks to update the collections. For example, for the upcoming March 22nd subscription updates, they will reflect in Alma no later than April 7th. Please note this ONLY applies to eBook Subscriptions at this time. We hope in the future to integrate a-la-carte orders and DDA, but we are not yet there. FAQs will be made available and posted on EBSCO Connect in the coming weeks in preparation for the subscription updates.

George Dragich
Academic Regional Sales Manager- WA, OR, AK, ID, MT
Office: 978 356 6500 x3493
Mobile: 206 516 9165
www.ebsco.com<http://www.ebsco.com/>
Watch a video<https://www.ebsco.com/email-signature-links/video/academic?utm_source=signature&utm_campaign=academic&utm_medium=email>

EBSCO.com<https://www.ebsco.com/> | Facebook<http://www.facebook.com/EBSCOInfoServices> | Twitter<https://twitter.com/EBSCO> | GooglePlus<https://plus.google.com/+ebscohostcom/posts> | LinkedIn<https://www.linkedin.com/company/ebsco-information-services> | YouTube<https://www.youtube.com/user/ebscopublishing> | Pinterest<http://www.pinterest.com/ebsco/> | EBSCOpost<https://www.ebsco.com/blog>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190311/5ba7092e/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 516 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190311/5ba7092e/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 14497 bytes
Desc: image003.jpg
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190311/5ba7092e/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 12948 bytes
Desc: image004.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20190311/5ba7092e/attachment-0005.png>