Expand my Community achievements bar.

SOLVED

Task report: Can I show the assigned to role NAME in a chart?

Avatar

Level 5

I'm working with a task report. It has a chart that has one (standard mode) Groupings:

Assigned To >> Role ID

 

We would like to show the role name instead of the role ID though, so I changed the Groupings to text mode. The report details groups by the role name as expected, but I cannot get the role name to show on the chart.

This is my Groupings:

textmode=true
group.0.displayname=Assigned Role
group.0.namekeyargkey.0=assignedTo:role:name
group.0.namekeyargkey.1=roleID
group.0.valuefield=assignedTo:role:name
group.0.valueformat=string
group.0.namekey=view.relatedcolumn
group.0.linkedname=assignedTo

 

Can someone tell me what I'm missing? Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You were so close! Instead of grouping by Assigned To >> Job Role; Group by Job Role >> Name. Workfront will assume the "assigned to" portion and this should give you the expected results.

Screenshot 2024-02-08 at 9.32.55 AM.pngScreenshot 2024-02-08 at 9.33.08 AM.png

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

You were so close! Instead of grouping by Assigned To >> Job Role; Group by Job Role >> Name. Workfront will assume the "assigned to" portion and this should give you the expected results.

Screenshot 2024-02-08 at 9.32.55 AM.pngScreenshot 2024-02-08 at 9.33.08 AM.png

Avatar

Level 5

Thank you, Monique! Guess I was making it harder than necessary.