This issue only occurs at the beginning of a new year but before the 1st week (Monday) begins .
This year example: All records with dates of 1/1/22 or 1/2/22 show as ‘week52’ which of course is incorrect.
Records with dates of 1/3/22 show correctly as ‘week01’.
Now when displaying ‘Both Periods’ which should show the current week 01 as the latest and 1/1 and 1/2 as the previous it is showing the 1/1 and 1/2 records as the latest and the 1/3 records (week01) as the previous. All subsequent records will continue to be shown as the previous until you get to the end of the year again.
So all dates at the beginning of a new year but come before the 1st Monday (the first week) are being giving a week value of ‘week52’ which is incorrect.
Here are the data records used.
The ZERO value records are filtered out.
