Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Alma

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Alma
    3. Knowledge Articles
    4. First day of the week in Analytics

    First day of the week in Analytics

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Article Type: Q&A
    • Product: Alma

    Question

    We wish to build some reports that look at circulation figures on a weekly basis. For us, the week runs Monday to Sunday, but in Analytics Sunday is treated as the first day of the week. Is it possible to change this so that Monday is the first day of the week?

    Answer

    The variable FIRSTDAYOFWEEK is defined as a Sunday. Although it is possible to change it, such a change would affect all customers and will not be done in the near future.
    However, there is a workaround to achieve this by using the Analytics function "WEEK_OF_YEAR". When for example doing an analysis on return dates, grouped by weeks, drag the Date Key field from the Return Date section, click "Edit formula"; then click on the "f(...)" button, Calendar/Date section, choose 'Week_Of_Year?'' expression. This expression automatically calculates the weeks from Sunday to Saturday and numerates them. In order to start weeks with a Monday, the formula must be changed as follows: WEEK_OF_YEAR(TIMESTAMPADD(SQL_TSI_DAY, -1,"Return Date"."Date Key"))

    Category: Alma Analytics - Alma


    • Article last edited: 5/9/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Fine and Fee Behavior when a Bursar system is integrated into Alma
      • Fiscal Period Closure Resources and FAQs in Alma
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Documentation
      Language
      English
      Product
      Alma
    2. Tags
      1. Alma Analytics - Alma
      2. contype:kba
      3. Resource Management - Alma
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved