You could use a calculated field:
Days = DATEDIFF('day',[Start],[Finish] )
You need to make sure the view is at the Work Step level of detail. For example Deal Name and Work Step are both rows. See attached.
DaysPerStep.twbx.zip 41.6 KB
Sorry, I just reread your question and it looks like you want to calculate days between steps.
There are probably many ways of doing this and the best solution might depend on what you're trying to show. The easiest to understand (for me anyway) is to create a set of calculated fields. For example
Day FICO Started = IF [Work Step] == 'FICO' THEN [Start] END
Day USA Started = IF [Work Step] == 'USA' THEN [Start] END
Days between FICO and USA = DATEDIFF('day', ATTR([Day USA Started]), ATTR([Day FICO Started]))
Another approach if you wanted to calculate the time between each step for each deal, would be a table calculation:
Days from previous step = DATEDIFF('day', LOOKUP(ATTR([Start]),-1), LOOKUP(ATTR([Start]), 0))
This creates something like the below:
DaysPerStep.twbx.zip 81.6 KB
Thank you for the quick response! Looking at your example, it looks like you have calculated duration of one workstep, which isn't what I am trying to calculate. I am looking to calculate duration from the beginning of one work step to the end of another. For example, How long did it take a Project to go from the start of SNL to the end of IRA.
Thank you again for your help!
1 of 1 people found this helpful
Sorry I read your first message too quickly. Let me know if my second response makes sense. You'll have to edit those formulas slightly to get what you want, but I think it should be straight forward.
These calculated fields may get a bit unwieldy if, for example, you are trying to calculate the difference between all the different steps (and combinations)---in other words, if there is a particular view you have in mind there may be an easier solution.