[Wactclc-alma] [EXTERNAL*]-Re: Changing loan status

[Martin, Melinda]

Good call! Kirsti saves the day again! 😊 Glad you all got it worked out. I will have to explore those!
-M

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Elena Bianco
Sent: Monday, February 14, 2022 11:12 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] [EXTERNAL*]-Re: Changing loan status

Thanks. Yes, I've done that for other table and I thought it would work here, but for some reason, maybe because this is a pivot table rather than the straight table view, and the type of loan is listed as a column heading, it won't let me edit the column head where it says "loan." It's really weird.

 I'm thinking I may have do something like the CASE statement that Kirsti recommended...

Elena



Elena Bianco

Systems & Technical Services Librarian

Skagit Valley College Library

2405 E. College Way

Mount Vernon, WA 98273





________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of Martin, Melinda <Melinda.Martin at scc.spokane.edu<mailto:Melinda.Martin at scc.spokane.edu>>
Sent: Monday, February 14, 2022 11:08 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] [EXTERNAL*]-Re: Changing loan status


Ah, yes – you can do that, too.

Under the “Results Tab,” click the button in the top left corner to “Edit View” – a second pane opens up where you click on the weird E within the column and change the Display Label.

-M



From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Elena Bianco
Sent: Monday, February 14, 2022 10:48 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] [EXTERNAL*]-Re: Changing loan status



Hi Melinda:



Thanks. I do know how to run the filters on columns. I want the loan status "none" items to show, but I want to change the heading of the column in my pivot table so people outside of the library knows that if a loan status is "none" that it means it's available. I want to change "NONE" to Read AVAILABLE



[cid:image001.png at 01D82196.E702C8C0]







Elena Bianco

Systems & Technical Services Librarian

Skagit Valley College Library

2405 E. College Way

Mount Vernon, WA 98273







________________________________

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of Martin, Melinda <Melinda.Martin at scc.spokane.edu<mailto:Melinda.Martin at scc.spokane.edu>>
Sent: Monday, February 14, 2022 9:23 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [EXTERNAL*]-Re: [Wactclc-alma] Changing loan status



Have you run a filter on the column?

If not – here is how…

When you go in to edit the report, you click “criteria” and then click on the Loan Status column settings button, drop down to filter, and then select “Is Equal to” and select those you wish to include. Then save the report or save it as something different (if you need to keep the previous report).

-Melinda



From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Elena Bianco
Sent: Monday, February 14, 2022 8:26 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Changing loan status



Good morning all. Does anyone know if it is possible to change the loan status category which currently is "none" to "available" in an analytics report?



Thanks!



Elena





Elena Bianco

Systems & Technical Services Librarian

Skagit Valley College Library

2405 E. College Way

Mount Vernon, WA 98273







This email is not from a Skagit Valley College email address. As such, the SVC IT Department cannot ensure its safety. Please use proper judgement and caution when opening attachments, clicking on links, or responding to this email..


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220214/51724c3b/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 37878 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220214/51724c3b/attachment-0002.png>