Looking to see if there is a way to make a calculated field combining two different date fields in order to create a line graph.
Data Set 1: All dates prior to Feb 18, 2023
Data set 2: All dates past Feb 18, 2023
End goal to be able to display line graph in one single visualization with all applicable dates
What you are describing sound like a union of two datasets. Union datasets is currently not supported natively within QuickSight unless the same datasource is used and custom SQL would be an option, like for Amazon Athena, PostgreSQL, etc.
At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have noted this in our internal feature request tracker.
To stay up-to-date with the latest QuickSight updates, please have a look at and subscribe (“watch”) to the What’s New/Blog category .