Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Report to display user role percentages

Avatar

Level 9

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
Level 10

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
Level 10

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 4

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

Avatar

Administrator

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