Frage
How to create output using only the most recent date in the data set using Tableau Prep.Example: If 2022/12/12 is the most recent date in the data set.
Zuletzt geändert am: 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
Umgebung
- Tableau Prep Builder
Antwort
Perform the following steps as demonstrated in the attached packaged flow.1. Connect to the attached data source 'test.xlsx'.
2. Click on the '+' button and add Clean Step.
3. Create a new calculated field with the following:
Name : MAX_Date
Calculation : {FIXED:MAX([Date])}
4. Click on Filter Values.
5. Enter the following calculation and save:
Calculation : [MAX_Date] = [Date]
6. Click on the '+' button and add Output Step.
7. Set the output options as desired to create the output.
Vielen Dank für Ihr Feedback zur Effektivität dieses Artikels.
Neuen Supportfall öffnen
Suche fortsetzen
Knowledge Base
Community
Produkthilfe
Schulungen und Lernprogramme