Voters 0
0
Future dates in query
- Closed
- Subscribe
 |
Data Team |
Hey all,
I'm getting week 53 from 2021 in this sheet:
docs.google.com/spreadsheets/d/1rOana6oIhuxhIQndLe_CrckSko-3NxS71rmasO-MKr4/edit#gid=0
In the platform, I don't see any issue.
I shared with dataslayer@atomic212.com.au.
Cheers,
Activity Newest / Oldest
Antonio Barral
Status changed to: Closed
Antonio Barral
Status changed to: Fixed
Data Team
Hi Antonio,
Year of Week works! Thank you!
Cheers,
Antonio Barral
Hi Anil,
Sorry for the late response. To solve this issue, you should use the "Year of Week" dimension instead of the "Year" dimension. It will return 2020 with week 53 instead of 2021 with week 53.
Best regards,
Antonio
Data Team
Hey Antonio,
Just a FYI, this is still not fixed.
Cheers,
Anil
Antonio Barral
Status changed to: In progress
Data Team
Hi Antonio,
Sorry for the late reply, I just saw your message now.
Thank you for the explanation which makes sense and the expected behavior would be:
Year Week Date
2020 53 2021-01-01
but right now I'm seeing:
Year Week Date
2021 53 2021-01-01
I can't filter week 53 since I'm pulling weekly data and it must be in the data set but I will update my formulas in the spreadsheet to fix it.
Kind regards,
Anil
Antonio Barral
Hi Anil,
Yes, you are right, it should show 2020 instead of 2021. I will try to solve this ASAP
Best regards,
Antonio
Antonio Barral
Hi,
The last week of 2020 includes 28,29,30,31 of December and 1,2,3 of January. So if the date range is from 2021-01-01 to today, all the dates from 1,2, and 3 of January will have associated week 53. I understand that's the proper behavior. Change data from week 53 to week 1 if the date is in 2021 will not be correct too.
If you want to avoid week 53 you can filter it
Best regards,
Antonio