It really depends on what the data looks like. Would you be able to post the workbook or sample workbook (twbx file)?
Thanks for the quick reply! I made a sample spreadsheet. Please see attached. An example of two things I would like to write functions for are
- EFG must be 100% prior to HIJ being 100%
- DEF must be within 10 days of ABC
Tableau Sample.xlsx 479.4 KB
Sarah, you're looking for something like this:
LOOKUP(SUM([% Complete]),-1)= 1
Or maybe something like this:
LOOKUP(SUM([% Complete]),-1)=<1 AND SUM([% Complete])=1
In your sample data they give the same answer, but if HIJ isn't 100% complete they would give different answers.
Sarah.twbx.zip 21.7 KB