問題
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.
上次修改日期 : 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
環境
- Tableau Prep Builder
答案
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.
感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程