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 , quick-sight , calculations , Business-Intelligence-Engineer	4	309	January 18, 2024
Date filter controls based on max and min date in dataset Q&A filters , parameters , feature-request , quick-sight , Business-Intelligence-Engineer	9	212	June 27, 2024
Default Date filter parameter for last input date Q&A filters , parameters , date , quick-sight	1	582	January 10, 2022
Creating max date available as default filter Q&A filters , quick-sight	5	4969	February 2, 2023
How to set calendar default date as my start date and end date in my data file Q&A analysis , quick-sight	4	1236	April 19, 2022

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