Dear AWS QuickSight Team,
I hope this message finds you well. I am currently working with a dataset that has been constructed using the SalesLeads table, Sales table, and SalesAttribution table from a Postgres database. The SalesAttribution table essentially establishes the relationship between SalesLeads and Sales, determining whether a Sale should be attributed to a specific Sales Lead.
In order to keep the dataset up to date, I have configured an incremental refresh on a daily basis with a window size of 1 day. This approach is intended to capture all the updates that have taken place during the previous day.
However, I am encountering an issue where the dataset is not being fully updated with the inclusion of new records. This comprehensive update seems to occur only when I manually initiate a Full refresh.
I appreciate any insights or guidance you can provide to help me resolve this matter effectively.
Thank you for your assistance.
ClosedAt is a DateTime column in the SalesLeads table