Skip to main content

Posts

Showing posts with the label latest date. max of date

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 t...