Expand my Community achievements bar.

Ability to report on Name fields instead of ID and chart this

Avatar

Level 4

5/12/17

Currently you can only add certain fields to reports with ID against them instead of Name, which results in a string of text.

Whilst you can fix this in text mode in most situations, this doesn't always work for groupings based on the ID field where you want Name instead.

Any manual fix also breaks the accompanied chart:

https://support.workfront.com/hc/en-us/articles/217982367-How-to-change-ID-to-Name-value-in-Reports-...

2 Comments

Avatar

Level 6

10/30/17

Agreed!

I can't think of many use cases where a report end-user would need to see the 32-character ID string in reports (ex. 5910ea3c022fa9015c9be495678d2b5c). Our use case would be to see the item in plain text (ex. For reports, it helps to see fields like Owner Name (or Home Group Name, Company Name, etc).

Currently, often the only way to show the Name is to go to Text Mode and code it in. And sometimes that doesn't work. I recommend that this be available from the field name pick-list, without needing to go to Text Mode.

Avatar

Level 3

2/14/24

Suprised not to see this idea with more likes. Even with some workarounds available within text mode this is still seen as a need for users.