Can you share a sample workbook or dataset for this please
Hi, I cannot open the workbook as I'm using an older version of Tableau
Use this calculated field and put it against the first two columns which is Customer name and order dates.
Next order Date
LOOKUP(ATTR([Order Date (Days)]),-1)
DATEDIFF('day',[Next order Date],ATTR([Order Date]))
Please set the Date Difference calculation as above using edit table calculation.
After this show quick filter for the Date Difference calculation and exclude Null as show in the earlier screenshot.
Let me know if this helps.
Thanks and Regards,