How to fill the missing data points in Quicksight

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:

But it’s not looking good. I need continuous data with a trend line. Is there any way to do it without using a date calendar?

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

they are the missing points, not the 0.

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.
image

1 Like

yes, those options are only available for line chart visualization.

I need a generic solution that can work for all the visualizations.

1 Like

@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!