Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
14 replies
Subscribers
8 subscribers
Views
4481 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Trying to get a report using a custom field that was added to the user account p
andrewk370
over 10 years ago
Trying to get a report using a custom field that was added to the user account page. The field is 'customField1'
I can pull back the field here - user("username","customField1")
But what I am looking for is how to pull back the field for every user in a group that I select, and count the different groups.
IE: My field is called group #, and user1 is group 1 and user2 is group 2, user3 is group 1, so I want to return group 1=2, group 2=1.
I want to put in either one group, or multiple groups and pull back the count of each group # for the entire group.
will it be something like this? =count(user(GroupName,'customField1')), but that gives me an error....
OriginalPostID-89194
OriginalPostID-89194
Discussion posts and replies are publicly visible
0
revat.anandsongkit
Appian Employee
over 10 years ago
Okay this should get you in the right direction.
with(
userAttributeList: apply(fn!user, getdistinctusers(topeople(ri!groupID)), "customField1"),
distinctList: union(local!userAttributeList, local!userAttributeList),
apply(rule!APP_createCountList(distinctValue:_,completeList:local!userAttributeList), local!distinctList)
)
rule!APP_createCountList has two parameters:
distinctValue
completeList
It should look something like this -
rule!APN_uiTextReadOnly(label: ri!distinctValue, value: count(where(like(ri!distinctValue, ri!completeList))))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
revat.anandsongkit
Appian Employee
over 10 years ago
This should return a list of text fields where the label is the value and the value is the distinct count.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bryangs
over 10 years ago
Revat, I work with AJ....is your last comment the info for a Tempo report? We are mainly a portal shop but have Tempo. Do you put the with(
userAttributeList.... in the content expression field on the Tempo Create Report page?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
revat.anandsongkit
Appian Employee
over 10 years ago
1) Correct. with() only works in Tempo.
2) What I would do is create a rule that the Tempo Create Report page calls and in that rule I would put the with(...) expression. So just to clarify, the Tempo Report calls ONE rule. That one rule contains the expression.
Makes sense?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<