[Wactclc-alma] Combining Date and Time for calculation

[Guidry, Wade]

Your best bet is to extract the loan and return date and time fields out of analytics, and do any field manipulation on the Excel side.

What about two calculations... subtract loan date from return date, and loan time from return time.

For the time column, you'll have to do something like "If return date is same as loan date, subtract loan time from return time; Otherwise, just include return time"

Since you'll have to account for same day returns vs subsequent day returns, and do the math differently for each.


Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org


From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Sally Sheedy
Sent: Friday, December 7, 2018 11:38 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Combining Date and Time for calculation

Hi All,

We are looking at data to see if our policies are set to maximally serve patrons' needs.

I've been asked to do an analysis of how long our two-hour items are out for and that won't be too difficult because you can assume the same day. In fact, we will ignore the outliers for items that are seriously late.  But I want to compare date AND time for Loaned and Returned for overnight and three-day loans. I can do this in Excel but I don't know how to add the date and time fields together in Analytics/SQL. I'd like to be able to use bins instead of grouping Pivot tables in Excel.

Any ideas?

Thanks!

Sally Sheedy
Systems Librarian
Whatcom Community College Library
237 West Kellogg Road
Bellingham, WA 98226
360-383-3287  (library 3300, college 3000)
ssheedy at whatcom.edu<mailto:ssheedy at whatcom.edu>
library.whatcom.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181210/23f3145e/attachment-0002.html>