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

Stephanie_Price
Stephanie_Price Member
in Charting

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?

image.png
Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited January 3 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

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited January 3 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

Categories