View: Actual Hours by Assignee

[JoseMa1]

Hello, I'm having issues with a View of Actual Hours by Assignee. At the Project level, I want to see total Actual Hours logged by each user when multiple users are assigned to a task. I was able to pull code from "https://support.workfront.com/hc/en-us/articles/217521577-View-Task-Planned-vs-Actual-Hours-per-Assignment">this article but it only calls out all instances when a user logged hours on the task (instead of total). Here's what I've got so far: listdelimiter= listmethod=nested(hours).lists name=Actual Hours by Assignee stretch=0 type=iterate valueexpression=CONCAT('(', {hours} ,' Hours) - ',{owner}.{name}) valueformat=HTML width=300 For example, the above gives me: (2 Hours - Name1), (3 Hours - Name2), (3 Hours - Name1), (1 Hour - Name1), (3 Hours - Name2) what I want is: (6 Hours - Name1), (6 Hours - Name2) Any help is greatly appreciated! Jose Magana Illumina - Marketing

[NRYNR]

When you pull records into the view through a collection, you can't aggregate, compare or sort. For these totals, I think you'll need to build an "Hours" report. Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank

[JoseMa1]

Hi Narayan, I have a separate hours report, but at the completion of a project, I was hoping to stay on the project page to see an aggregate of hours each person entered (when multiple users are on a task), instead of having to go to a separate report to view this every time I close out a project, which sounds like might not be possible. Maybe others have had some luck with this. Thanks! Jose Magana Illumina - Marketing

[JoseMa1]

@Narayan Raum Brainstorming a bit, do you know if there's a way to pull that data in, but not through a collection? Jose Magana Illumina - Marketing

[NRYNR]

If you're looking for a consolidated representation of the project and hours spent on tasks, I think a dashboard on a custom tab might be the way to go. "https://support.workfront.com/hc/en-us/articles/216722938-Creating-Custom-Tabs"> Here's the documentation on that. With a custom tab, you can have embedded reports that give you the summary you're after. Here's one I built for a project recently... Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank