I am looking for a calculation that would allow me to highlight the last 7 days on my graph.
I currently have the equation shown below, but I realized this is showing me current week, whereas I would like last 7 days (regardless of day of week).
Hi - not certain that this is it but you want to have the difference in the dates to be 7 or less
Does this get you closer
(DATEPART('year',today()) = Datepart('year',[Ship Date]))
and DATEDIFF('dayofyear',TODAY(),[Ship Date] ) < =7
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...