Report to display user role percentages

Question

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

listmethod=nested(USRROL).liststextmode=truetype=iteratevaluefield=timePercentagevalueformat=HTML This doesn't seem to produce any values. Thanks.Nick

Richard_Le_ · Accepted Answer

Hi Nick, The following text mode should do it! valueexpression=CONCAT({role}.{name}," - ",{timePercentage},"%")listdelimiter=
listmethod=nested(userRoles).listsvalueformat=HTMLdisplayname=All Job Rolestextmode=truetype=iterate Best Regards,Rich.

amybillmayer · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO