Reports - grouping tasks by multiple teams assigned to a task

[SethPorrazzo]

Hi All,

Now that WF allows multiple teams to be assigned to a task, I'm trying to figure out if there is a way to group these tasks by teams in reports. Currently I can only group by the first team added to the task, but I want to capture the work for each team assigned (even if it double counts the task in the report).  Has anyone figured out a way to pull this off?  Appreciate the feedback.

[Richard_Le_]

Hi Seth,

You will be able to achieve this with an Assignment report type, grouped by Team name. 

Assignment reports show a line item per assignment. So if you had a task assigned to two teams, two items would appear on the report (one for each team).

Best Regards,

Rich. 

[SethPorrazzo]

Thanks Rich, this looks like the way to go.  However, I noticed that quite a few of my tasks are being grouped under "No Value" even though there is an actual team assigned to the task.  Where is the "Team Name" or "Team ID" field pulling data from?

[Madalyn_Destafney]

It's pulling their Home Team in their profile or Other Teams (whichever you've specified).

[SethPorrazzo]

I checked their account and they have a home team that isn't displaying.

[Madalyn_Destafney]

Looks like you've sorted things out with Rich, but it may be that these assignments (issues/tasks) are not assigned to Teams, but rather to individual users.

[Richard_Le_]

Hi Seth,

The team ID or name should be pulling from the team(s) that are assigned to the task.

On your assignment report, are you filtering for tasks only? (i.e. taskID is not blank). Assignment reports pull in any kind of assignment, whether it be a task or issue. What you might be seeing are issues in your report that do not have a team assignment.

Best Regards,

Rich. 

[SethPorrazzo]

there are teams assigned to the task but still show up as unassigned.  I notice there are several teams fields to choose from, which is associated with the actual team assigned to the task?

1.  Task >> Teams Assigned
2.  Team >> Name
3.  TeamID
4. Assigned To >> Team

[Richard_Le_ · Accepted solution]

In my example, I have used Team>>Name. In the following screenshot there is a task with two teams assigned:

In an assignment report, I get two entries (one for each team)

[SethPorrazzo]

Thanks Rich that did the trick.