Report to display user role percentages

[NickVa1]

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

[Richard_Le_ · Accepted solution]

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.

[LizaSh1]

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

Liza

[NickVa1]

Wonderful. Thanks for this, Richard!

[amyb35793975]

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

[kynabaker16]

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