Weeks one week different
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
-
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
3
Answers
-
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
3 -
Yep from what I am seeing I bet that's exactly what it is. Thanks Michelle, super helpful!
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive