Can you list aggregate using calculated field in Quicksight?

Can we combine multiple values into one by combining the common values and commas separating the remaining ones? The result should appear the same as the set union operation.

Example 1:

For a field1,

Value1 = {1,2,3,4}
Value2 = {2,3}
Value3 = {3,4,5}

Result: {1,2,3,4,5}

Example 2:

Screen Shot 2022-08-15 at 14.26.31
into :
Screen Shot 2022-08-15 at 14.30.25

Please note they are values of a single field. They are not defined and can be random.

Thank you! It is in our roadmap. @emilyzhu

Currently, please push down the calculation into database, for example, listagg in redshift: LISTAGG function - Amazon Redshift