Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    First day of the week in Analytics

    • 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
https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/First_day_of_the_week_in_Analytics
knowledge.exlibrisgroup.com
crawl=CC-MAIN-2019-35
99221
application/http; msgtype=response
sha1:PF7PX6BKLLFNX27GHFVREKTOND5FWTK3
<urn:uuid:3f2c3b9f-eb24-4aae-a375-eb73caebfec3>
2019-08-24T21:55:35Z
35.168.122.151
text/html
sha1:DOWHGS5BTVMFJS7S5SZINQESDR3XJKGV
<urn:uuid:0a29a404-fcab-47aa-a00d-072e3b4191eb>
https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/First_day_of_the_week_in_Analytics
response
<urn:uuid:697113af-780b-4b85-b511-889d8892ddf7>
isPartOf: CC-MAIN-2019-35
publisher: Common Crawl
description: Wide crawl of the web for August 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-207.ec2.internal
software: Apache Nutch 1.15 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/