Skip to main content
Level 2
August 25, 2020
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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
NicholeVargas
NicholeVargasAccepted solution
Adobe Employee
August 26, 2020

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!

8 replies

NicholeVargas
Adobe Employee
NicholeVargasAdobe EmployeeAccepted solution
Adobe Employee
August 26, 2020

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!

Translate
alferaj16Author
Level 2
August 26, 2020

thank you!

Translate