Data Studio
3.5K members online now
3.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Generate Weekly Time Series Report using ISO Week of the Year

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'd like to create a weekly time series report showing the past 8 or so weeks of users. It should show a weekly trend, with the week starting on a Sunday.

 

With the ISO Week of the ISO Year dimension the week start doesn't line up because that dimension has weeks starting on Monday, per this discussion:

https://www.en.advertisercommunity.com/t5/Data-Studio/Data-Studio-Data-doesn-t-match-GA-Data-for-wee...

 

This appears to be the same problem with the ISO Week of the Year dimension, too.

 

What's the magic combination?

 

Thanks,

Stephen

 

ISO Week of the ISO Year

The week starts on a Monday (February 27)

iso-week-of-the-iso-year.png

 

 

ISO Week of the Year

Weeks are numbered.

iso-week-of-the-year.png

Generate Weekly Time Series Report using ISO Week of the Year

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

This seems like a simple problem/request - is there no solution? How does one create a graph showing weekly data in Data Studio?