Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages


Get What You Need

How to Chart by Task Assignee Home Group (or Home Team, or Primary Role)Oasis

A recent challenge in the community forum caught my attention this week. A number of folks would like to be able to group Tasks by the Primary Assignee’s Home Team (or Home Group, or Primary Role), but — in short — that data is “too far to reach” from within Workfront. This post illustrates how to Get What You Need.

“You can’t always get what you want
You can’t always get what you want
You can’t always get what you want
But if you try sometimes well you just might find
You get what you need”

— The Rolling Stones

Step 1. Expose the IDs


Step 2. Create the Formula


TIP: you could also improve the formula to highlight Users whose Home Group (or Home Team, or Primary Role) are missing, which might also be helpful

Step 3. Add the Parameter and Paste the Formula


Step 4. Confirm the Data


Step 5. Set the Report Grouping


Step 6. Set the Report Filter


Step 7. Set the Report Chart


BONUS: Download our Excel Helper File


As I often say, “It always works out in the end. So if it hasn’t worked out, it isn’t the end.”

All, People and Teams, Projects, Reporting, Resource Management, Setup

Leave a Reply

Your email address will not be published. Required fields are marked *