Display Role Name in an Hour Report, Matrix Format | Adobe Higher Education
Skip to main content
N
NickVa7
Level 9
February 1, 2021
Beantwortet

Display Role Name in an Hour Report, Matrix Format

  • February 1, 2021
  • 2 Antworten
  • 536 Ansichten

Hi WF Community,

I have an Hour report set up to display in the matrix format. I want one of the matrix groupings to be by role name; however, role id is the only available option. Looking at id's in a report isn't user friendly. Wondering if there's a way to show the role name while still in the matrix format.

Thanks.

Nick

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von imgrund

Hi Nick - sadly not that the moment. What I tend to do is use a calculated field on the previous object type that gives the name and then use that.

So like reports that need people (which I'm assuming you have here), I have on their custom form calculated fields that give me Home Team Name, Manager's Name, Role Name, etc.

On projects, I have Portfolio Name and Program Name.

You just go to the User Custom Form, add the calculated field, and the "formula" is Role.Name

Now, this only works for Primary Role, Home Team, but it has been helpful in charts and Matrix reports where you can't text mode groupings.

2 Antworten

imgrund
Adobe Employee
imgrundAdobe EmployeeAntwort
Adobe Employee
February 1, 2021

Hi Nick - sadly not that the moment. What I tend to do is use a calculated field on the previous object type that gives the name and then use that.

So like reports that need people (which I'm assuming you have here), I have on their custom form calculated fields that give me Home Team Name, Manager's Name, Role Name, etc.

On projects, I have Portfolio Name and Program Name.

You just go to the User Custom Form, add the calculated field, and the "formula" is Role.Name

Now, this only works for Primary Role, Home Team, but it has been helpful in charts and Matrix reports where you can't text mode groupings.

    N
    NickVa7Autor
    Level 9
    February 1, 2021

    Creative workaround. Thanks, Anthony. That just might do the trick.

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...