String aggregation?

Q&A
,
1

Hello,

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 …

Thanks

Stringagg in calculated field
2

No this is not possible in a Quick Sight 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.