Relative Date Filter Issue

Hi @abacon @DylanM
i have 2 queries , is there any solution for these 2 issues

Issue 1

When we select “This Year” option In the dashboard date filter it is showing “Jan 1, 2023 to Dec 31, 2023“ date range, whereas when we click on select date, then the date range is showing **“Jan 1, 2023 to Jan 1, 2024“

Issue 2:

If user enters a number in “Last years” option text box. same number is getting updated to “Next years” text box
image

image

Hello,

For the first one you can try Exclude Last (checkbox) with value as 1 day, this would then show same selection in data range as well.

It is not working as expected, as it is considering end date as 31 dec and the date outside dropdown is displaying 30th dec

To include the end date in the filter range. Edit filter → select the option “include end date”

This option wont work for filter type " Relative dates", IT will work only for filter type “Date & time range”.

Hello @Akshaymanjunath, are you still trying to figure out a solution for this problem you were facing in QuickSight? If so can you follow-up with any more information you found during your testing so we can help guide you to a solution? Otherwise, if you were able to resolve this on your own, would you mind posting the steps you took to achieve the expected output? Thank you!

Hello @Akshaymanjunath, I am going to archive this topic. If you still need assistance resolving this issue, please post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts. Good luck!