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
)}
Tableau desktop

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

Back to Tableau Desktop cookbook page