Difference of 'This day' and 'Till day' in the Relative Date filters

[lary_andr]

@praveen.gp

m trying to understand the difference between the ‘This Day’ and ‘Till Day’ options when using a relative date filter in Quick Sight.

• When I set ‘Relative by’ to ‘Days’ and select ‘This Day’, I get results for the current date.
• When I select ‘Till Day’, I also seem to get results for the current date.
• I tried using parameters (e.g., setting the end date as ‘start of last 7 days’), but there’s still no visible difference between ‘This Day’ and ‘Till Day’ in the data returned.

Could someone explain the functional difference between ‘This Day’ and ‘Till Day’ in the context of relative date filtering? Does ‘Till Day’ include data from Day 0 up to and including today, or is it supposed to behave the same as ‘This Day’? Any clarification or examples would be appreciated.

see the below screenshots.

Hello @praveen.gp Hope this message finds you well!!

The difference between ‘This Day’ and ‘Till Day’ in qs relative date filter lies in the scope of the data they include.

• ‘This Day’: This option filters the data to include only records from the current date (Day 0). It is strictly limited to data generated or recorded on today’s date.

• ‘Till Day’: This option, on the other hand, includes all data from Day 0 (the current date) and all preceding days, depending on the range you’ve set. For example, if you set the filter to ‘last 7 days’ and choose ‘Till Day’, it will include data from the past 7 days up to and including today.

If you’re seeing no visible difference between the two, it might be due to the way your dataset is structured or the specific range you’ve applied. For instance, if your dataset only contains data for the current date, both options will return the same results. However, if your dataset spans multiple days, ‘Till Day’ should include a broader range of data compared to ‘This Day’.

you can use this community question too:

Till day vs This day

Is there anyone know the different between This day and Till day in date filter? When i chose Till day, the data end at 03:59 am. If i chose This day all the data shown. And this happen to when i chose between This Week vs Week to date, This Month vs Month to date, and so on. Is there any setting in quicksight to change that? My time: +7 GMT AWS region: Asia Pacific (Singapore).

To clarify further, you could test with a dataset that has records spanning several days and adjust the filter range to observe the difference. Let me know if you need additional help!