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?
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: