You are pulling data from Oracle and have several sheets - otherwise I would recommend pivoting the data - it is a better solution but that may mess other things you are doing
see the attached
I wasn't able to tell if each group had a common min date
but for each group the min date is (if you can pivot the data this can all be done in a single formula
after you do this 4 times the min of the min is
min is a binary function so nesting was required to get the min of the 4
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.
Newmodel OFS version_v10.2.twbx 626.8 KB
Thank you for the quick response. I will have to try and manually recreate what you did at the moment I have Tableau 10.1 and will need to have my company approve the upgrade.
How can I modify to account for where I have a zero in one of the data points. As you have done it it works in all cases as long as none of the sum's are not zero?
It's almost there where as you suggest I can do a pivot on the result but with this slight issue.
Newmodel ODN version_v10.2.twbx 641.8 KB