Weeks one week different

AdamC
AdamC Grand Forks, ND ⚪️

Afternoon,

Working in a data set and I have three dates 10/4/22,10/5/22,10/6/22 and when we build a graph card and set the display to week it is showing these dates as week 41. But these should be week 40, last week. Just to test it we put in todays date of 10/10/22 and it says week 42, which is next week.

Seems somehow Domo is ahead one week? Does Domo calculate weeks differently in the background.

Thanks!

Best Answer

  • MichelleH
    MichelleH 🟣
    Answer ✓

    Hi @AdamC do you know if you have a fiscal calendar enabled on your instance? If you don't, then Domo's native week groupings consider Week 1 as January 1 through the end of that calendar week. Since January 1, 2022 was a Saturday, Week 1 2022 is comprised of just one day by this logic, which may differ than your company's fiscal weeks. Domo's Fiscal Calendars give you the ability to customize how to group fiscal weeks, periods, quarters, and years.

    https://domohelp.domo.com/hc/en-us/articles/360042924254-Using-a-Fiscal-Calendar

Answers

  • AdamC
    AdamC Grand Forks, ND ⚪️

    Yep from what I am seeing I bet that's exactly what it is. Thanks Michelle, super helpful!