I have a dashboard that displays an average of some values. I use the ‘Year & week’ period function. All was working correctly until Jan 1, 2022 when any entry of 1/1/22 or 1/2/22 comes up ‘week52’ of year 2022. But today (1/3/22) of course starts a new week (Monday) but the widget is showing the records dated 1/1/22 and 1/2/22 as the latest (week52) and the current (1/3/22) as being older (week01).
I will attach a screenshot.
Here are the dates used:
3 entries are 1/1/2022
3 entries are 1/2/2022
1 entry is 1/3/2022
This should probably be in the bug section as well.
Thanks for any insights you may have.
Note: the zero value records are filtered out
These dates certainly don’t belong in 2021 but the ‘Week’ doesn’t begin until Monday Jan 3. So seems these dates are orphaned but they certainly shouldn’t be tagged as week52. What to do with them? I have filtered them out temporarily but I wouldn’t want to have to remember to do this every year. Thx
