Group Rows: New Column

[HenryJS]

Hi all,

How can I group rows of data

So 'Advert - Considering' and 'Advert - Not Progressing' are one new row called 'Advert Actions'. And the counts are added together

UserName	ActionRef	ActionName	ActionDate
Katie Peachey	3169223	Advert - Considering	17/04/2020 11:49
Katie Peachey	3169183	Advert - Considering	17/04/2020 10:40
Sally Miller	3146976	Advert - Not Progressing	31/03/2020 10:15
Sally Miller	3146971	Advert - Not Progressing	31/03/2020 10:13
Sally Miller	3145364	Advert - Not Progressing	31/03/2020 10:01
Sally Miller	3144313	Advert - Not Progressing	31/03/2020 09:35

[Anonymous · Accepted solution]

Hi @HenryJS,

Any similar strings in your records that used to create a new column as a group? If not, I'd like to suggest you try to create variables of values and used them to compare with current value to assign the group.

Sample:

Group =
VAR listA = { "A", "B", "C", "D" }
VAR listB = { "E", "G", "H" }
RETURN
    IF (
        [Column] IN listA,
        "GroupA",
        IF ( [Column] IN listB, "GroupB", "Ungrouped" )
    )

Regards,

Xiaoxin Sheng

[amitchandak]

@HenryJS,

Refer if this can help: https://radacad.com/grouping-and-binning-step-towards-better-data-visualization