How to shift first week of year from December to January?

The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced this and how did you get around it?
Best Answer
-
It is because there are days in 2025 (January 1, 2, 3, 4) that are part of the week starting December 29th. So for the week to start with Jan 1 would be an incomplete week and would not be consistent with the weeks to follow on the graph.
You could format your data in an ETL to be grouped by a custom calendar week start date (we do this for our team's sprints where we have our own calendar of dates that are important to graph by (sprint start date), graph by month instead of week, add an annotation to the first week explaining why it shows 2024-12-29, or as you suggested use week number instead of date.If I solved your problem, please select "yes" above
0
Answers
-
It is because there are days in 2025 (January 1, 2, 3, 4) that are part of the week starting December 29th. So for the week to start with Jan 1 would be an incomplete week and would not be consistent with the weeks to follow on the graph.
You could format your data in an ETL to be grouped by a custom calendar week start date (we do this for our team's sprints where we have our own calendar of dates that are important to graph by (sprint start date), graph by month instead of week, add an annotation to the first week explaining why it shows 2024-12-29, or as you suggested use week number instead of date.If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 107 SQL DataFlows
- 648 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 733 Automate
- 186 Apps
- 471 APIs & Domo Developer
- 62 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 137 Manage
- 134 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive