Ignoring missing date values

When date/time information is missing from a dataset, the corresponding values plot as zeros on line and area graphs. It is possible to "smooth" the data by interpolating the missing values.

To ignore missing dates in a plot, navigate to the Marks menu, and select the Ignore missing dates option.

Note that some of the spikes are 'smoothed' in the second image.