Hi Team,

I have each month data snap shot, which have been extracted the 1st week of next month For Ex: July 17 extracted 1st week of Aug 17.The column name is date_extracted shows the date of the August instead of July month.

When i create the dashboard in tableau, how can I convert / interval to display the previous month in tableau.i.e July month instead of Aug

Through SQL query I use the below.

SQL query - ( Table Name.Date_Extract  -  Interval '1 Month') as Date_Extract

Please advice, how can i do it in tableau.

Sorry I don't have snap shot or tableau workbook attached