I have a report which shows the weekly sales. Now i want to be able to have a filter that allows the user to filter the data to see any week. However i want the filter to default to the most recent week that is visible for them.
My week data is not in date format as it is just a number pulled from our calendar database and joined in alteryx.
I wasnt sure whether a MAX filter would allow for the filtering to specific weeks too.