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.

Nicola Simboli

Nicola Simboli Senior Analytics Engineer

15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.

Back to Tableau Desktop cookbook page