Create calculated field which dynamically adds value a another column in comma separated on aggregation

Question & Answer
,
1

in aws quicksight , on aggregation, is it possible to create a calculated field which store /computes dynamically comma separated string which appends all the unique elements of the a column values

Table
key value CID

X 23 VXV
X 27 HHS
Y 66 HHH

Expected after avg of value column

key value CID

X 25 VXV, HHS

Y 66 HHH

2

@David_Wong @Ashok @DylanM

3

Hello @mukeshusc2018,

as of my knowledge I do not think that it is possible to do it as dynamically and easy as you want.
However, this post could probably still help you: Aggregattion on string column

Best
Nicolas

4

Hi @mukeshusc2018,
It’s been a while since we last heard from you, were you able to find a work around for your question or do you have any additional questions remaining?

If we do not hear back from you within the next 3 business days, I’ll go ahead and archive this topic. But if you have any further questions past that, feel free to create a new topic for discussion and link this page for relevant information.

Thank you!

5

Hi @mukeshusc2018,
Since we haven’t heard back, I’ll go ahead and archive this topic. However, if you have any lingering questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!