Date Ranges Selection in Quicksight Q

[David_Wong]

@Sahil
I found that’s how relative date filters work in QuickSight in general. It’s not specific to Q. Take a look at this post:

Relative date filter using last N periods

When setting a relative date filter using last N periods (e.g. years, months, weeks, etc), QuickSight is only including full periods. For example, today is 2023/01/11, so when I set the filter to last 12 months, I’m expecting the underlying date range to be 2022/01/12 to 2023/01/11 but QuickSight is using 2022/02/01 to 2023/01/31. It’s excluding Jan 2022 completely and including future dates in Jan 2023 because it wants to include the full month. [image] I’m just wondering how other users feel…

QuickSight includes the full period. Even though we’re still at the beginning of August, it includes the whole month of August. I think for most people this is not the desired behaviour, so we should have both options like I suggested in my post.