Report to display user role percentages | Community
Skip to main content
Level 9
November 9, 2020
Solved

Report to display user role percentages

  • November 9, 2020
  • 3 replies
  • 954 views

Hi WF Community,

Does anyone know of a report or view whereby I can see users roles and percentages (per role, if they have more than 1 role)?

I noticed in the API Explorer that there's a User Role object with a timePercentage field. Wondering if this is the right one? I tried creating a view on the Users list, adding a custom text mode column, and referencing the above field as a collection:

displayname=Role Percentages

listdelimiter=<div>

listmethod=nested(USRROL).lists

textmode=true

type=iterate

valuefield=timePercentage

valueformat=HTML

This doesn't seem to produce any values.

Thanks.

Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

Hi Nick,

The following text mode should do it!

valueexpression=CONCAT({role}.{name}," - ",{timePercentage},"%")

listdelimiter=<br>

listmethod=nested(userRoles).lists

valueformat=HTML

displayname=All Job Roles

textmode=true

type=iterate

Best Regards,

Rich.

3 replies

Richard_Le_Community AdvisorAccepted solution
Community Advisor
November 9, 2020

Hi Nick,

The following text mode should do it!

valueexpression=CONCAT({role}.{name}," - ",{timePercentage},"%")

listdelimiter=<br>

listmethod=nested(userRoles).lists

valueformat=HTML

displayname=All Job Roles

textmode=true

type=iterate

Best Regards,

Rich.

January 21, 2022

This was exactly what I was looking for TOO, now a year later!!!! Thanks!

Liza

NickVa7Author
Level 9
November 10, 2020

Wonderful. Thanks for this, Richard!

amybillmayer
Level 4
November 12, 2020

Thank you!! This is exactly what I was looking for as well!

kynabaker16
Adobe Employee
Adobe Employee
November 12, 2020

Yay!! And I just love hearing that someone found what they needed from the community!