Expand my Community achievements bar.

Add Other Teams as a filter option on reports

Avatar

Level 5

5/26/17

Some of our reports need to be filtered to only show data from members who belong to a certain Team. Only Home Team is available as a filter in reporting, so, in order for a person's data to display on a report, we have to make sure we remember to make their Home Team match the filter on the Report.

This works OK, but it means that if a person belongs to more than 1 team, they can only show up on 1 report that is filtered by Home Team. If we could select Other Teams as a filter on a report, then we wouldn't have to remember to make the report filter match their home team, and we could also have the person appear on all of the reports that are filtered by Team.

15 Comments

Avatar

Level 6

6/15/17

This has been the basis of MANY of my help requests. Currently there is no way to pull together all work items for all members of a team. The only other way is to list a string of names.... which creates a maintenance nightmare if teams members are on-boarded/off-boarded.

Avatar

Level 6

10/26/17

I've recently learned that Workfront has solved this for Other groups. The variable name is "otherGroupIDs" under the search tab for "User" in the API explorer.

Using this, you can run a timesheet report for any group, and it will look for all user membership regardless of "home" or "other".

This is EXACTLY what is needed for teams.

Avatar

Level 4

1/31/18

I agree with the original request. When attempting to create an hours report, there is no filter option to include only those who are assigned to a team, which may not be the home team. As a result, each individual name must be entered on the report as filter. In the future, if there are changes to employees roles, the filter on the report would need to be maintained. If an option for "Other Team" is available, the report would continue to pull appropriate results as individual account settings are updated.

Avatar

Level 7

5/7/18

I have run into this problem also, especially when crossing internal depts. - ie: Digital Mktg jobs that require a designer or copywriter. (since majority do not)

I have to filter by Digital Portfolio and then make sure to include anything with a design or copy task....gets cumbersome.

great idea!

Avatar

Community Advisor

2/17/23

I completely agree and have found many needs for this. I've also tried to figure out a text mode solution but keep running into walls.

Avatar

Community Advisor

3/20/24

@jon_chen can we see what the product team thinks about this one? The ability to pull Other Groups is already available, why not Other Teams? Seems like it could be low hanging fruit development-wise and a huge help for reporting.

Avatar

Employee

3/20/24

This is already available, and has been for some time. We should have circled back to resolve this idea.

 

The primary difference is that it just doesn't wear the "home" prefix in the report builder. Look for "Team IDs" instead. See the example filters step in the report build below.

 

Team IDs when creating filters.png

Status changed to: Delivered

Avatar

Community Advisor

3/21/24

@MattMi3 you've been holding out on us!! This is the best pre-Summit announcement! I'm so excited to update (and finish) so many reports! Is it safe to assume this is available for other types of reports beyond User; such as assignment & project?

 

@CynthiaBoon@NicholeVargas & @LeslieSpier - FYI in case you haven't heard yet!