Solved
Is there a way to calculate the actual duration for an issue?
I want to see how long it takes each issue to complete, but using actual entry dates vs actual completion dates. I do not want to use the planned dates.
NicholeVargasAccepted solution
Employee
Aug 26, 2020 3:03 PM UTC
Jocelyn,
There are a few different ways to calculate this value using text mode. If you wanted to take into consideration all (calendar) days, rounded to 2 decimal places, you would use the following text mode code:
displayname=Issue Duration
valueformat=HTML
valueexpression=ROUND(DATEDIFF({actualCompletionDate},{entryDate}),2)
If you wanted to only take into considering weekdays, you would use the following text mode code:
displayname=Issue Duration
valueexpression=ROUND(WEEKDAYDIFF({entryDate},{actualCompletionDate}),2)
valueformat=HTML
Additional information regarding calculated data expressions can be found here: https://one.workfront.com/s/article/Calculated-data-expressions-679086747
Another option would be to create a calculated custom field on an Issue Custom Form so that you can group or chart by the Issue Duration value.
If you have any questions, let me know!