Missing data on visual types in QuickSight
You can customize how missing data points are visualized in your line charts and area charts. You can choose to have your missing data points appear in the following formats:
-
Broken line: A disjointed line that breaks when a data point is missing. This is the default missing data format.
-
Continuous line: Displays a continuous line by skipping over the missing data point and connecting the line to the next available data point in the series. To show a continuous line, the Show date gaps box on the X axis pane should be unchecked.
-
Show as zero: Sets the value of the missing data point to zero.
To customize a visual's missing data settings
-
On the analysis page, choose the visual that you want to format.
-
Choose the Format visual icon in the upper right corner of the visual to access the Format visual menu.
-
Open the Y axis pane of the format visual menu and navigate to the Missing data section.
-
Select the missing data format that you want.
