Good morning, I have a filter that represents a date, but I have it as a string because I need a dropdown-type filter. I want the maximum date from the dataset to appear every time I open the report. Is this possible?
Thanks!
Hello @SolSar62 , Hope this message finds you well.
You can configure a filter to always display the maximum date from your dataset when opening the report, even if your date is stored as a string.
First, ensure that your date column is converted from a string to a date format using the parseDate function, like:
parseDate({your_date_column}, 'yyyy-MM-dd') to achieve this conversion.
Once the date is correctly formatted, proceed to create a date filter in QuickSight. When setting up the filter, select the single value filter option and configure it to use the Max aggregation function on the date column. This setup will ensure that the filter automatically selects the maximum date available in the dataset. Finally, apply this filter to your report or visualisation, ensuring that it takes effect each time the report is opened, thus displaying the maximum date by default.
Hope this helps you!
Hi @SolSar62,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @SolSar62,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!