Text Mode for User ID to Name in Chart

[ThomasNe2]

I have a Type Ahead Name Field in the system that I am trying to Group by and pull into a Chart Report.

When I group by the Name the Chart view shows as No Value with a solid block as if there is no Grouping applied. I can group by the ID but then the ID's show in the Chart view and make the report difficult to view. 

How can I tweak this so I can group correctly by the ID but display the name in the Chart? 

The Text Mode is here from the Grouping if that is useful? 

group.0.iscollapsed=true
group.0.linkedname=T2 Picked Up By
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=T2 Picked Up By
group.0.namekeyargkey.1=User:name
group.0.valuefield=T2 Picked Up By:User:name
group.0.valueformat=customReferenceObjectAsString
textmode=true

[skyehansen · Accepted solution]

text mode groupings do not get picked up in a chart. For that, you would need a custom calculated field.

[ThomasNe2]

Hi Skye 

How would this work? Add a Calculated Custom Field to the Report and Group on that?