Adjusting Week Numbering in Custom Time Hierarchies for Year-End Continuity

Questions & Answers
,
1

I created a report using the ‘5-4-4’ code from the ‘Custom time hierarchies’ feature, and it has been quite useful. However, I encountered a few issues:

The week numbering for December 31, 2024, and January 1, 2025, is the same, which is problematic. I would like to have December 31, 2024, as the last week(52rd week), and January 1, 2025, start as Week 1. Specifically, I aim for the following structure:

  • December 31, 2024: Week 52
  • January 1, 2025: Week 1
  • December 31, 2025: Week 52
  • January 1, 2026: Week 1

Could you please advise on how I can achieve this specific week numbering in my reports?

1 Like
2

I am unable to edit the post.

  • I want the last day of each year to display as 52, 53, or more, depending on the case.
  • example)
    • 2024-12-29: 53W
    • 2024-12-30: 53W
    • 2024-12-31: 53W
    • 2025-01-01: 1W
    • 2025-01-02: 1W
    • 2025-01-05: 2W