I’d like to set up a filter in a QuickSight dashboard that, by default, selects the most recent date to optimize the query performance. However, users should still be able to select other dates if needed. Has anyone implemented something similar?
Hello @elotorre
Hope you’re doing well!
Regarding the implementation, we do not have any direct method but users have implemented solution provided here:
[+] How to set Latest date as Default Date in datetime Parameter
This addresses in setting the last date in your dataset as the default date in QuickSight, you can implement dynamic default parameters. This requires creating a separate dataset that contains the maximum date from your original dataset.
You would need to include user information in this dataset along with the maximum date value.
After creating this dataset, you can create a datetime parameter and select “Set a dynamic default” option, then choose your dataset and the column containing the maximum date. This approach allows the parameter to automatically select the latest date available in your data.
Referred:
[1]How to set Latest date as Default Date in datetime Parameter
[2] 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 - #2 by Max
Thank you for your response. However, the solution provided does not dynamically detect the latest available date in the dataset to use as the default value for the filter. Additionally, while the default should be set to the latest available date, we also need the rest of the dates to remain visible so that the value can be changed as needed.
Hi @elotorre
With the workaround, dynamically the dates will not be fetched you have to update the other dataset to fetch the latest available dates. As shared → it requires creating a separate dataset that contains the latest date from your original dataset. And this needs to be updated whenever new data is available.