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

JC_U
Participant I
a2ff934a-1a59-4ebf-ab83-dc9ba0226606.png
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? 

0 3 735
3 REPLIES 3

Dawid
Participant V

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

8733e427-401b-4276-a109-7007ac7b2b2e.png

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

JC_U
Participant I

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

JC_U
Participant I

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

900f4d29-68d3-4608-8683-9a528ea0b800.png
Top Labels in this Space
Top Solution Authors