Not exactly sure, but is this what you expect?
I only found "Sales ID" to distinguish the duplication. So used smallest Sale ID as 1st order.
what were the expectations
I looked into the data - where you have multiple records associated with an Order ID at the min date it looks like there are multiple sales ids -
each with the same duration - I think that is throwing you off but I am not sure
In any event first the fixed order date
then the duration calculation-note this is where I used avg()
then the ratio
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Tableau Test Workbook_v10.5.twbx 88.4 KB
You are very welcome.