Week of the year seems odd


Hi all,


I am showing my graph interval by week. But the weeknumbers seem odd.


week 53 - 2020 = 30 december 2020
week 2 - 2021 = 3 january 2021


Is week 1 only 2(to 4) days? Can someone explain this? This seems like a mistake in Domo rather than in my data, right?


  • jaeW_at_Onyx

    it's not a mistake in Domo.


    The first week of containing dates in January starts on a Friday.  If your week starts on Sunday, then your first week would only have two days (Jan 1 and Jan 2).


    What you want to happen is you want Domo to 'just know' that Jan 1 and Jan 2 belong to the last week of December... which is business logic, not how a calendar actually works.


    Short version of the story is you should implement a date dimension where you can control how business logic is applied to your dates (in this context, how weeks are counted when a month or year starts in the middle of the week).


    Alternatively @GrantSmith recommends calculating the WeekNumber of the Start of the Week.

    WeekNum( Date - DayOfWeek )

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"