Hi, I have record data as shown in the table below : Id NumbersInText 1 One 2 One 3 One; Two 4 Two; One 5 One; Three; Two 6 Three 7 Three 8 Two 9 One; Three I am trying to aggregate this data is such a way that I can how the report below : NumberInText Count One 6 Two 4 Three 4 Please help me with it.

Question

Aggregate Record Data

Forum|Forum|3 years ago
January 18, 2023
2 replies
0 views

Hi,

I have record data as shown in the table below :

Id	NumbersInText
1	One
2	One
3	One; Two
4	Two; One
5	One; Three; Two
6	Three
7	Three
8	Two
9	One; Three

I am trying to aggregate this data is such a way that I can how the report below :

NumberInText	Count
One	6
Two	4
Three	4

Please help me with it.

arulk0002

Hi,
Follow the below link
https://docs.appian.com/suite/help/22.4/fnc_system_queryrecordtype.html

S

shamima0001Author

I tried it, aggregation based on single value in the field works fine with this approach. However, I have multiple comma separated values in the field on which I am trying to aggregate.

Sign up

Login with SSO

Login to the community

Login with SSO