Skip to main content
Known Participant
Jan 18, 2023 11:53 AM UTC
Question

Aggregate Record Data

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.

    2 replies

    arulk0002
    Inspiring
    Jan 18, 2023 12:13 PM UTC
    Known Participant
    Jan 18, 2023 1:08 PM UTC

    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.