Search code examples
looker-studio

How does one plot an ISO week time series plot in Data Studio that does not begin on Week 1?


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?


Solution

  • 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)