Still new to this so here is what im trying to get:
IF YEAR(#TODAY()#) THEN (DATEDIFF('day',[Date Asset Requested],[Assets Shipped]) ) END
The DATEDIFF Calculation works just fine, What i wanted to do with it was apply a live filter over the top to generate a range so that it was not reporting on the whole document just the date range,
The Doc is 3 years deep but i wanted to limit it to reporting to year 2012, then i wanted to use the same rule but limit it to a range of 7 Days, I dont want user input, so i thought using the TODAY function would be good, such as from today report on last 7 days, OR for the year, Report for the year on whatever year today is present within..
but i dont know how to mix and layer functions within Tableau..