I have 2 controls, Start Date and End Date. I would like to have the min and max of a particular field to be selected as default values of the controls. Is there anyway to do it. I tried creating a calculated field, max or min({field},,pre_filter) but later realized that we can’t add calculated fiel…

You can create a dataset that looks like this: [image] 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. Add the above dataset to your analysis. Create a datetime parameter fo…

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

Q&A

Max February 2, 2023, 4:46pm 2

You can set up dynamic defaults for the parameters.

Here’s another post on dynamic defaults.

Last date as default in a dashboard

Topic		Replies	Views
Date Range parameter Q&A parameters , date , calculations , Business-Intelligence-Engineer	4	322	January 18, 2024
Date filter controls based on max and min date in dataset Q&A filters , parameters , feature-request , Business-Intelligence-Engineer	9	313	June 27, 2024
Assign maximum value to String parameter(Date) Q&A	5	1400	September 5, 2025
How to create a dynamic default value for a control Q&A error , filters-controls-and-parameters	12	2454	October 15, 2025
Last date as default in a dashboard Q&A filters , Business-Intelligence-Engineer	5	129	June 4, 2025

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

Related topics