Quicksight weekly comparison

Hi,

I am using Quicksight, 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.