You might consider creating a calculated field similar to the following:
- datediff('day',[observation date],now())
Once created, place on the filter shelf. Edit the filter, go to the Top tab, select By Field and populate it with:
- Top | 1 | observation date | Minimum
Hope this helps,
I had to assign the following (using SuperStore
* Top| 1| Order Date|Maximum
to a the Calculated field created from
* datediff('day', [Order Date], now())
during the extract and it worked to produce an extract with the [Order Date] = 12/30/2012 which is the largest value in
the Superstore example Excel file that ships with Tableau.
Nice. This will be handy in a few other situations as well.
See attached sample .twbx
MaxDateExtract.twbx.zip 44.1 KB