Skip to main content

Posts

Showing posts from December, 2020

Filtering to the Single Most Recent Date

Filtering to the Single Most Recent Date Tableau recommends the below 4 options to filter a worksheet to the most recent single date: Option 1  Use the Latest Date Preset feature. Unlike the additional options listed below, this option will allow for the use of the filters card to select additional dates.      Option 2 Select  Analysis  >  Create Calculated Field . In the Calculated Field dialog box that opens, enter a name for the field. In the formula field, create a calculated field similar to the following: [Order Date] = {FIXED : MAX([Order Date])} Drag the newly created calculated field from the Measures pane to the  Filter  shelf. In the Filter dialog box that opens, select  True ,   and then click  OK .   Option 3 (if LOD calculations are not possible): Select  Analysis  >  Create Calculated Field . In the Calculated Field dialog box that opens, enter a name for the field. In the formula field, create a calculated field similar to the following and click  OK : IF MAX([O