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.
Last Modified Date: 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
Environment
- Tableau Prep Builder
Answer
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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials