Show Grouping Name Instead of IDs in Reports

[ArthurChalamet]

Hi All, 

We have been trying to create reports to compare the number of tasks assigned to users from two companies in Workfront. The companies are both separated by the value of 'company' and 'home group' in Workfront. 

We have built many types of reports. Mainly, projects, tasks and also hours reports. One thing that irks me is that most of the groupings can only be done for the object ID and not the object name. For example, hours report can only be grouped by owner > company ID instead of company name. 

This will not be feasible to be viewed by leadership and end users. I tried editing the text mode and it works for columns (view). but when it comes to summary or chart view, the information of company are shown as no value instead of the names. 

The below screenshot showing the grouping name works fine on column view: 

The below screenshot showing the grouping name not working for summary view: 

The same goes to the chart view. Is there anyway that I can do to fix this issue?

All help is greatly appreciated. Thank you!

Arthur

[Richard_Le_]

Hi Arthur,

The best way to overcome this is to create a custom form to be attached to each user profile in the system. On that form, you would have several calculated fields that reference the users home group name, home team name, company name etc. These fields would then be available to reference in your reports instead of using ID which isn't human readable.

For example adding a calculated field with: {homeGroup}.{name} would return the home group name of that user which you can the pull into your hour reports and group/chart by etc.

Best Regards,

Rich.