Hi, I’m looking to set a dynamic default value for a control.
I created a parameter and control for a string field, and I’d like to set a default value for that control. I’d like the default value to be the max value in the control list, meaning it would be dynamic. With every new dataset update, the max value in the string field will change, and thus in the control list. I’d like the control list’s new max value to be the new default value.
Here’s an example:
I have a string field that has a list of dates in the MM/DD/YYYY format. (I did not make the data type of this field “Date” and kept it a “String,” because QuickSight does not show the aforementioned date format I’d like). Upon making this a control, the control list looks like this:
With the next update of the dataset, a later date will show (e.g. 06/01/2023). I would like the new default value of the control to be 06/01/2023, considering it will be the new max value.
I understand that I can set a static default value but this would require a manual change every time the dataset is updated. I would like this to be dynamic, and the latest date (max value) would automatically show.
Hopefully the question’s clear. Thank you!