String aggregation?


My dataset is like this :

ID ticket Date Operator
1 01/01/2023 A
1 01/01/2023 B
2 01/01/2023 C

I’d like to have a calculated field with all “Operator” of the ticket concatenated, like that :

ID ticket Date Operator Operators
1 01/01/2023 A A,B
1 01/01/2023 B A,B
2 01/01/2023 C C

Is it even possible ? I see sum, avg, but it’s only for numbers, not strings …


No this is not possible in a QuickSight calculated field.

I can mark it as a feature request.

In SQL you can do this with string_agg or another function depending on the database.