Week of the year seems odd

Reply
Yellow Belt

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?

Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!