Amazon Quicksight adds Missing Data control for line and area charts

Amazon QuickSight now supports ‘Missing Data’ control for both line and area charts. Previously, line charts only supported ‘missing data’ treatment for datetime fields. Now, we have added support for categorical data as well for both line and area charts. Instead of displaying broken lines (default behavior), Authors can also choose to display broken lines as either continuous lines by directly connecting to the next available data point in series or interpolate these missing values with zero and display a continuous lines. More details can be found here.

This is a companion discussion topic for the original entry at

For me there is no option “Continuous line” for a Line Chart. I have a date aggregated by month on x axis and calculated field on y axis (runningSum(sum({someCount}), [truncDate(“MM”,{createdAt}) ASC]))