I want to create a filter for report dates that will filter all visuals. I was able to create the filter but it comes up as a calendar of which you need to manually select a date. I need to create the filter as a dropdown menu with specific dates. I have attempted to create this by converting the dates column into strings but it messes with other visuals and therefore I do not want to attempt this method. Is there a way I can keep the data type as dates and create a dropdown menu?
1 Like
Hi @agopal
you could create a new string_date field instead of converting the existing one!
BR
1 Like
Hi @agopal,
Welcome to the Quicksight Community! Thank you for posting your question.
As ErikG suggested, you can create a new field.
To get the dropdown -
After you have added a filter to sheet, try to click edit (as shown below)
Format Control pane opens, click on Control options as below and select dropdown option
If you want to give specific dates, then you can select specific values under values and give your dates.
I hope that helps!
Thank you,
Shravya
Hi all, I did create another column for the dates in string-type. Unfortunately still running into an issue as the filter inaccurately applies unless it is of date type. But am wondering if there is an option to create a dropdown menu for date type or does Quicksight not have this functionailty. Currently for date-type data the filter type options are: date and time range, relative dates and top and bottom filter.
Hi @agopal
i tried something
new field stock_date_str = left(toString({stock_date}),10)
Use that field as a dropdown filter.
But if you are using it that way to cant do date and time range, relative dates and top and bottom filter anymore.
BR
Hi @agopal
Has Erik’s solution work for you? I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
GL
1 Like
Hi Erik, apologies for the confusion. The reason creating another column with the dates as Strings did not work is because I am attempting to make the filter a ‘Til Date’ Filter. So When I select a date on the filter it will add up all results in the year to the date I have selected. As you can understand that of course couldn’t work with Strings as it cannot be recognized as earlier/later dates when string. Currently I have the filter as type Date and time range and am using a condition of ‘Before’ so that it accumulates the numbers till date and have check marked ‘Include this date’ so that it is essentially adding anything less than or equal to the date selected.
Hi @agopal
what if you create a integer field as measure. you could use it in a filter with “less than or equal to”
BR