Is there a way to calculate the actual duration for an issue? | Community
Skip to main content
A
alferaj16
New Participant
August 25, 2020
Solved

Is there a way to calculate the actual duration for an issue?

  • August 25, 2020
  • 1 reply
  • 1495 views

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.
    Best answer by NicholeVargas

    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!

    1 reply

    N
    NicholeVargasAccepted solution
    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!

      A
      alferaj16Author
      New Participant
      August 26, 2020

      thank you!

      Terms & ConditionsAccessibility statement

      Loading footer...