I have a String field which represents date values, We have created date values from backend database by attaching a prefix like “Dateinstring= 001:YYYY-MM-DD” so that the latest date will come first in dropdown since quicksight cannot sort the values in filter dropdown in descending order. While assigning prefixes to dates , each time after refresh the prefix of dates will change.
We are using a single value string paramater and that parameter is connect to the dataset and “Dateinstring” column. So the Parameter default value I have to change manually after each refresh.
In the below snapshot currently the first value is 001:2024-11-21, So the default value added to the parameter is 001:2024-11-21
When we add December data , the value become 001:2024-12-05
Here each time after refresh i have to update the default value manually and republish the dashboard. Is there any way to dynamically set the value with prefix 001: in the dropdown to be the default value???
Or else Is there any way to sort the dates in descending order in a dropdown control so that latest date will appear first in dropdown, ??
as shown in you screenshot there is a “dynamic default” option. but you would need a user mapping and a single field that contains only the last value (001:2024-12-05).
I was trying that all the way. But I dont need any user level mapping for the date field and dont have user specific groups I need this latest date to be displayed for all the users. But I have a employee name field so can I use that for mapping in the same dataset?
Also for returning the single value using calculation, i couldn’t return the latest date from the records. Initially I used ifelse in calculation, but that will return 2 records. Then I tried multiple approaches and calculations to get only the latest value using quicksight calculation dynamically. Nothing worked. Could you help to derive logic for returning the latest value from the string field?
Hi @Ganga,
Following up here to see if you are still encountering the same issue or if you were able to find a work around solution to implement? As far as I’m aware, this type of functionality is not currently possible in QuickSight as you can not use a aggregation in your parameter, therefore the system would be unable to replace with most current date.
You would need to use some type of system that does not include the date in the string; therefore the parameter values could remain static but still be returning the correct data as it’s changing.
Let us know if you have any additional questions, otherwise, if we do not hear back within the next 3 business days, I’ll close out this topic.
I need to change the parameter values dynamically to default to latest value of a string or the first value of that column. Could you please provide us a workaround, because manually updating the parameter value after each refresh for multiple reports is becoming a hectic task now.
Hi @Ganga,
There is currently no feature in QuickSight to dynamically set the default in that demeanor. I’ll go ahead and mark this as a feature request to promote visibility to the support team.
