How Calculate (and Filter) to the Max Day in a Data Set in Tableau 

Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
Let's say you want to filter a Tableau worksheet to only contain data from the latest date in the data set. That's pretty simple if the latest date is consistently today or yesterday. You can just use a relative date filter!
But what if the most recent date in the data set is less consistent? Maybe you want to see orders on the latest transaction date but sometimes the business goes a couple days without transactions (or doesn't transact on certain days of the week). A filter which only kept data for "Today" wouldn't be very effective!
Check out this video to learn how you can use a FIXED Level of Detail expression to calculate the latest date in a data set and a custom calculation to filter and only keep data from that date.
Formula:
[Order Date ] = { MAX([Order Date ]) }
Tableau Public Workbook: public.tableau.com/app/profil...