Expand my Community achievements bar.

SOLVED

Report to display user role percentages

Avatar

Level 10

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 1

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

Liza

Avatar

Level 10

Wonderful. Thanks for this, Richard!

Avatar

Level 4

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

Avatar

Employee

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