You can drop fields "Project ID" and "Project status" to the rows. Then go to Analisis->View Data and export all.
This will save the two columns of todays data as a csv file. You can name the column "Project status" of the saved data as "Yesterday project status". Now after data is updated you can blend updated data with saved one using the field "Project ID".
Then you will have both todays and yesterdays statuses of the projects.
The data is coming from SQL Server. we have a table with current day status only. Tomorrow it will over write by tomorrow status. There is no Yesterday data.
What Levan is saying is that Tableau does not support versions in that way - you would need to have separate today and yesterday versions of you viz
when you refresh the data the data set is replaced with the new data
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.