I want to set min(date) from dataset as start date of date control and max(date) as end date of date control. How to achieve it in quicksight

[David_Wong]

1. You can create a dataset that looks like this:
   
   

In your dataset use SQL to calculate the MinDate and MaxDate. Depending on your use case, it can be the same value for all users or a different value for each user.

2. Add the above dataset to your analysis.

3. Create a datetime parameter for the start of your date range, e.g. FromDate. Click “Set a dynamic default” and select the dataset that you created, and the MinDate column.
   

   

4. Repeat step 3 for the end of your date range.

5. Create a date filter and select “Use parameters”. Select the parameters that you created as the start date and end date parameters.