Amazon Quicksight - Dynamic filter latest week by default

I think the question is fairly simple. I would like to have a dynamic filter on Quicksight. I have the column week which is a number (3, 4, 5 and 6) for example. The data is refreshed every week.

We want to show only the latest week by default (out of weeks 3, 4, 5 and 6, I want to filter by default on 6), but then the users can select if they want to see more weeks.

The week after, the default filter would be 7, and so on.

Is there a way to tell the filter to automatically filter by rule of MAX(week) or something like that?

It would be very helpful. I have other alternatives but they are not that great.

Solution

Second solution.

Add Filter
Choose week
Type Top and Bottom Filter
Show Top write 1
By week ( use max aggregation)

Pasting an image from an analysis that I do the same thing for integer column year