질문
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.
이 문서의 효과에 대한 의견을 제공해 주셔서 감사합니다.
새 사례 열기
검색 계속
기술 자료
커뮤니티
제품 도움말
교육 및 자습서