Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Text mode to give duration between Issue entry date and task completion

Avatar

Level 3

Hi Community

I am struggling with Text mode again despite reading text mode for beginners

 

I have a task report that shows for our partner integration builds the, Requests/issue - entry date (Hit the inbox on:) task name = Complete - Go Live > Completed on - actual completion date (Completed on:)

Am trying to add a column to the report that shows me in days the duration between, Hit the box on: and Completed on

Everything i have tried in text mode leaves the report column blank

 

Any thoughts how to look up the issue entry date to the task completion date to see how long we have taken workfront gives me actual duration but thats project conversion to project completion

4 Replies

Avatar

Level 3

Hi Ian, 

 

If I understand correctly, you have Requests that are converted to Tasks, and you want to see the total time from the date the Request was Submitted and the Completion Date of the Task. Correct?

 

If that's the case, you will want to create a Request Report and create a text mode expression for entryDate to actualCompletionDate. It would like this:

 

valueexpression=ROUND(DATEDIFF({actualCompletionDate},{entryDate}))

 

 

There is one thing you'll want to make sure happens when converting to a task. You want to make sure this is checked " Keep the original request and tie its resolution to this task" at the bottom the convert panel. What this does is mark the request complete when the task is complete. There by getting the Actual Completion Date. 

 

Hopefully this is helpful. 

 

_Joaquin 

Avatar

Level 3

Hi Joaquin

So its a request we convert to a project and in that project i have a  task that contains > Complete - Go Live so when 100% it reports a partner is now live on our system, there is a following task called 5 days check, where my team ensure the partner tracking etc is solid, When this task is marked complete it auto closes the project

 

Hope that makes sense
Though using what you have shared at least some are showing one correct 12 working days, one looks incorrect 2 days and two at 0 though that may be it needs 2 decimal places to show

 

added as this

displayname=
durationunitfield=durationUnit.value
linkedname=direct
namekey=duration
querysort=durationMinutes
textmode=true
valueexpression=ROUND(DATEDIFF({actualCompletionDate},{entryDate}))
valuefield=durationMinutes
valueformat=compound
viewalias=duration

Avatar

Level 3

Hi Ian, 

 

Looks like you have some conflicts in your text mode. Trying slimming it down to just these three lines:

 

displayname=Duration

valueexpression=ROUND(DATEDIFF({actualCompletionDate},{entryDate}))

valueformat=HTML

 

See if this helps. If not, I may need to see your report. 

 

-Joaquin

Avatar

Level 3

Hi Joaquin

Ok added as that but am still seeing some 0 and one that hasn't calculated as expected

 

report is filtered as the below