Pregunta
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.
Fecha de la última modificación: 21 Dec 2022
Example: If 2022/12/12 is the most recent date in the data set.
Entorno
- Tableau Prep Builder
Respuesta
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.
Gracias por brindarnos sus comentarios sobre la eficacia de este artículo.
Abrir nuevo Caso
Continuar buscando
Base de conocimiento
Comunidad
Ayuda sobre los productos
Capacitación y tutoriales