I have a field in Tableau that has only the financial month like (1,2,3,4,5,6,7,...etc ) so I need to add that in the filter and when I open the workbook for next month I need the month to be selected automatically to 2
Tableau
My problem is as it is not the date datatype I do not have the (filter to the latest date option) is there any other ways .
Dates are the only type of filter field that you can specify the most recent value for when the workbook is opened. That's because dates are the only thing that really has a thing that is definitely the most recent. The month number doesn't, and Tableau can't tie the selected values in a filter to the values of another field. If the user is only allowed to select one month at a time, then you could use a parameter for your filtering, and set that to the most recent month number when the workbook was opened, but I don't think there's a way to calculate a value and use that in a filter list for what should be selected.
