Quicksight function similar to Athena's array_agg

Hi There, I am looking to create a new column using a Quicksight calculated field which returns all values of a certain group split by a comma

data:
customer, fruit
1,banana
1,orange
1,apple,

result
1, ‘banana,orange,apple’

I can do this in Athena using a group by and the array_agg function but I was wondering if there is any way to do this in the quicksight layer?

Thanks

Hi @bknight15,

There’s no function to do this in QuickSight. If you’re already using Athena, I would suggest that you group your values there before you bring them to QuickSight.