Improve Filter performance for Direct Query Dashboards: 2023 Amazon QuickSight Learning Series

[@AnubhavGupta-t2c]

Hi, I have a dataset of transactions against merchant IDs with a granularity of one minute. This means that for a particular merchant ID, there could be any number of transactions with a gap of one or more minutes. I want to create an analysis that compares transactions on a weekly basis. For example, the user can select a start date and end date for week 1, and another start date and end date for week 2, and the analysis should show the comparison between these two weeks. I tried adding a filter based on date ranges with 4 parameters for each date (week 1 - start date and end date, week 2 - start date and end date). However, the result is not showing any data, though it works fine with a single date range. Any help in adding the filter would be appreciated.