0

Future dates in query


Avatar
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,

A

Activity Newest / Oldest

A

Antonio Barral

Status changed to: Closed

A

Antonio Barral

Status changed to: Fixed

Avatar

Data Team

Hi Antonio,

Year of Week works! Thank you!

Cheers,


A

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


Avatar

Data Team

Hey Antonio,

Just a FYI, this is still not fixed.

Cheers,
Anil


A

Antonio Barral

Status changed to: In progress

Avatar

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


A

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


A

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