Today all of the tables we have using Year & week (Mon-Sun) went haywire.
We have a report showing only december data, but all Year & Week dimensions are showing up as null or with an April date.
This is happening across clients and venues. I'm seeing this issue both for the Facebook connector & the AdWords connector. See the attached photo:
Does anyone have a fix for this? Is the team working on a fix?
there indeed is something strange on how Data Studio is reading the year&month dates. We're currently looking in to it and get back to you once we've discovered the reason.
could you please refresh you queries and let us know if they work correctly now with year & month. Thanks!
I just refreshed and it's still not working.
It looks like it's taking the week number and splitting that up into month/day.
So week 48 year 2017 is becoming 4/8/2017
week 49 year 2017 is becoming 4/9/2017
week 50 year 2017 is null because there is no 5/0/2017
week 51 year 2017 is becoming 5/1/2017