Hey everyone, I’ve created a trend visualization that displays transaction trends on a daily basis. However, if we’re missing data for certain days, those gaps are not shown in the visualization. If I enable the “show data gap” option, it will display the missing data points, like this: [image] …

Hi @achourey are the missing points actualy missing or 0? BR

they are the missing points, not the 0.

yes, those options are only available for line chart visualization. I need a generic solution that can work for all the visualizations.

@achourey any chance you can carry forward the last values on data level?

Hi @achourey , It’s been awhile since we last heard from you; did you have any additional questions regarding your initial question? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you!

Hi @achourey , Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you!

How to fill the missing data points in Quicksight

Q&A

David_Wong September 25, 2024, 5:09am 4

Hi @achourey,

If you use a line chart, you have a few options to handle missing data. I don’t believe those options are available with area charts.

Topic		Replies	Views
Linechart : show previous value when date is missing Q&A date , feature-request , quick-sight , visuals	1	502	July 12, 2023
Amazon Quicksight adds Missing Data control for line and area charts What's New	2	818	December 17, 2024
Line chart issue - data gaps Q&A charts , analysis , formatting , date , quick-sight , visuals , calculations , Business-Intelligence-Engineer	11	489	February 26, 2024
Filling date gaps Q&A charts , formatting , feature-request , quick-sight , visuals , dataset , Business-Intelligence-Engineer	4	851	October 4, 2023
Connect lines for missing data Q&A analysis , formatting , feature-request , quick-sight , calculations	3	281	July 20, 2023

How to fill the missing data points in Quicksight

Related topics