Continuous x-axis for date

[lbl]

Line chart - x-axis based on a date field.
There is missing YYYY-MM (e.g. 2024-Feb to 2024-Jul and 2024-Sep) from the chart since there is no data for those YYYY-MM. How to make the x-axis to be continuous to include those missing YYYY-MM?

Thanks.

[Giridhar.Prabhu]

Hi @lbl

There is a property to enable Continous Line that you can use to have continuous line.

New additions to line charts in Amazon Quick Sight

Amazon Quick Sight is a fully-managed, cloud-native business intelligence (BI) service that makes it easy to create and deliver insights to everyone in your organization or even with your customers and partners. You can make your data come to life with rich interactive charts and create beautiful dashboards to be shared with thousands of users, either directly within the Quick Sight application, or embedded in web apps and portals. Line charts are ubiquitous to the world of data visualization …

But be aware that your dataset should have dates for the missing periods. Meaning the date should be a separate dimension and you have a left join on your dataset so even if there is no data for the dates the dates themselves are available in your dataset. Then the continous line will work