If needed, you CAN share a workbook.
Check out the video here:
But I think something like this should work:
DATEDIFF('day', LOOKUP(attr([Order Date]),-1), ATTR(Order Date]) )
This is a table calc, so depending on how you have your sheet set up, you might need to tell tableau the dimensional order in which to evaluate it.
If I had a sample workbook, I could show you that.
I was trying that but without the min function. The lookup function wanted an aggregation or a constant and I didn't know how to satisfy that requirement with a date.
This formula works.
1 of 1 people found this helpful
MIN, MAX, AVG, ATTR ... These are all ways to satisfy Tableau's thirst for an aggregate. Often all result in the same thing, but sometimes not.
I'm going to mark Jim's reply as the correct answer here.
Good to know. I couldn't share the workbook due to privacy issues but I appreciate your help as well.