Rolling date feature in filter

[Tanu_13]

I have a datetime filter what does the rolling date feature do.

[Xclipse]

Hi @Tanu_13

Rolling date feature in datetime filters allows selection of dynamic, relative date ranges (like last 7 days, this month, nor previous quarter) instead of a fixed calendar date. This means filter values automatically adjust based on the current date/time, keeping dashboard data fresh without manually updating filter settings each time.

Please refer to the below Quick Sight documentations and community posts this might be helpful for you.

Adding date filters - Amazon Quick

Customize date and time values of an analysis - Amazon Quick

Rolling Date with different time start

Hello @Owen, I think the best solution for this will be to create a startDate and endDate parameter. Make sure you set the granularity down to the minute. Then create a control for each so the user can set date values with a calendar selection. Now instead of directly filtering your visuals with the values that are returned from the parameters, use them in an ifelse statement to return your date field where it is greater than or equal to those parameters with the datetime change accounted for. …

How to set the day before yesterday as default date for a visual

hi everyone, I’m trying to use the filter feature to set the before yesterday as the default date for my dashboard, but I only find a relative complicated way to do so by creating a dim table and setting a dynamic default for a parameter. So I’m wondering if there is a more easy and straightforward way to do so? thanks

[Tanu_13]

Hi @Xclipse , can you explain me what do you mean by each time , because when the user visits the dashboard first time the default rolling date is selected in the filter but when user refresh the dashboard the default rolling date is not selected.

[Xclipse]

Hi @Tanu_13

On the first visit to the dashboard, the default rolling date configured in the filter setup (ex: last 7 days or this month) is automatically applied. This ensures new users see current, dynamic data without needing to manually choose a date range.

After a user changes the filter or refreshes the dashboard, the most recent filter selections are stored locally in the browser session or possibly in user specific dashboard settings, so the default rolling date is not reapplied on every refresh.

[Tanu_13]

Is there any way to set default rolling date after every refresh

[Xclipse]

Hi @Tanu_13

It is not possible to automatically set the default rolling date after every dashboard refresh. Once a filter is changed, the most recent filter selections are stored locally in the browser session. As a result, the default rolling date will not be reapplied on every refresh unless the filters are manually reset in the dashboard.

[Xclipse]

Hi @Tanu_13

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @Tanu_13

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!