Tableau Desktop snippets
How to calculate second max DATE overall
Suppose to start from a Tableau Desktop workbook with the data of Star Wars saga movies release date.
// Second max date overall
{ FIXED : MAX(
IF [US Release Date]={ FIXED : MAX([US Release Date])}
THEN NULL
ELSE [US Release Date] END
)}

You can download a working example of this Tableau Desktop workbook in the Resources area.