Team - Need help to display latest tuesday in tableau with respect to current date.
Example like if today date is 14thAUG2016, then output will be 9thAUG2016. (just passed Tuesday)
How to achieve this in tableau.
Try this: DATETRUNC('week',[Date],'tuesday')
If you only wanted to filter for the latest tuesday you could have, for example, [YourDate] = DATETRUNC('week',[Date],'tuesday') and set to True in the filters shelf.
You would also have a filter for only the last 7 days to make sure only the latest Tuesday is returned.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...