Possible to fill in missing dates with previous date's value or discontinue the lines?

  • 27 May 2022
  • 3 replies

Example time series chart

I have a line chart here and want to avoid the drops to 0 and spikes back up. Is it possible to fill in NULL dates with the previous dates value on the Looker-side? Or alternatively, discontinue the lines so the lines don’t go to 0. 


How do ya’ll deal with missing dates? 

This topic has been closed for comments

3 replies

Userlevel 7
Badge +1

What information do you get when looking at context menu when you click a cog icon of the date dimension?

Is it “Can’t fill in missing dates?” or “Fill in missing dates”?

@Dawid The option I get when clicking the wheel for date dimension is: “Remove filled in dates”. 

@Dawid not sure what it did but this is what it looks like now: