Question
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.
Date de dernière modification : 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
Environnement
- Tableau Prep Builder
Réponse
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.
Merci de nous avoir donné votre avis sur l’efficacité de l’article.
Ouvrir un nouveau cas
Continuer la recherche
Base de connaissances
Communauté
Aide produit
Formation et tutoriels