Posted On: Sep 9, 2022

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.

The new Missing Data control will be available in Amazon QuickSight Standard and Enterprise Editions in all QuickSight regions - US East (Ohio and N. Virginia), US West (Oregon), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), Canada (Central), Europe (Frankfurt, Ireland and London), South America (São Paulo) and AWS GovCloud (US-West).