Pergunta
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.
Data da última modificação: 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
Ambiente
- Tableau Prep Builder
Resposta
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.
Obrigado por fornecer seu feedback sobre a eficácia deste artigo.
Abrir novo processo
Continuar a pesquisa
Base de dados de conhecimento
Comunidade
Ajuda do produto
Treinamento e tutoriais