I have set of data from 1990's until October 2020 that I have to filter by latest month & year. For example: for month of October 2020 data is for the new customer and the rest is existing customer. This filter will be use in other worksheet as well. I know the concept but don't know how to achieve this. Anyone can teach me on this as I am still new to tableau.
1 respuesta
Hi Sharifah,
I have created calculations for "first order date", "min order date", "max order date" and label for "new or existing customers".
Please find attached workbook for reference.
