I am trying to overplot four years of data to see how they compare over a year. I have created a field called season to separate the four years and have another field called week corresponding to the ISO week. However, I cannot figure out the way to make the plot start at, say, week 31 instead of week 1.
Here is the plot of what I have so far:
Data Studio ISO week plot starting at week 1
Is there a way to start the time axis at a different starting week?
My guess is, Data Studio itself as a visualisation tool does not have the functionality to wrap the dates around as you wish.
One option would be to look to the query/dataset you're using and shift the dates such that (pseudocode):
offset = 31
if week >= offset then shift -(offset) // resets to origin (left shift)
if week < offset then shift +(52-offset) // resets remaining data (right shift)
You can create a time series in Data Studio filter to begin your ISO Week. I have tried that with YEARWEEK filter and seem to be working fine.
Here's an example:
And now with a time series filter: set to Jan 1st 2017
If Including (YearWeek) is going to solve your problem then, this is how you do it right from Google Data Studio.
Although, I have to say that when I tried that with ISO Week(ww) filter, it doesn't seem to be working fine. My understanding is that, when aggregating time series by ISO Week (ww) it encounters duplicate week numbers: 01, 12, 13 in 'ww' when your plot has more than one year of data. I found YEARWEEK to be a possible work around.
It can be achieved by:
Style Tab, scrolling down to the X-Axis section;Range by Data.Google Data Studio Report and a GIF to demonstrate:
