Add Other Teams as a filter option on reports - Status changed to: Delivered

[#1]

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.

[#2]

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.

[#3]

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.

[#4]

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.

[#5]

I agree with the request.

[#6]

I agree also, this would be very helpful!!

[#7]

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!

[#8]

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.

[#9]

@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.

[#10]

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.

[#11]

@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!