Text code for assignment breakdown for actual hours?

Question

Hi, We use the following text code to show the planned hours by role/person (which has been great). How can I modify this to show actual hours by role/person? displayname=Assignment Breakdownlistdelimiter=
listmethod=nested(assignments).liststextmode=truetype=iteratevalueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))valueformat=HTML

KellieGardner · Accepted Answer

Yep! I planned to use a task report to compare Planned by Role vs. Actual by Role.Try this: listdelimiter=

listmethod=nested(assignments).listsname=actual Wrk Assignment(s)stretch=0textmode=truetype=iteratevalueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") -",{actualWorkCompleted}/60,IF({actualWorkCompleted}/60>ABS(1)," Hours"," Hour"))valueformat=HTML

Rafal_Bainie · Answer

I first thought Kellie is right, but here are the reasons why I think this won't work:

1. overarching assumption is you use task report, although this isn't specified in your post

2. planned hours are tied to task and to assignment and cannot be tied to anything else. Meaning, all planned hours on assignment level do sum up to the total planned hours on task level

3. what is true in 2 for planned hours isn't true for actual hours. These can be logged by virtually any user on a given task, and further more hours cannot be logged on assignment level

4. no 3. is in a sense confirmed by API explorer and the fact that actualWorkRequired field is not available on assignment level and that is effectively what you are trying to pull into report.

Finally, the best approximation I was able to get when playing around was by using "actualWorkCompleted". But I'm not sure this yields correct results always, mainly due to no.3

Cheers!

Rafal

Sign up

Login with SSO

Login to the community

Login with SSO