How Use LISTAGG function in Quicksight as Calculated Filed

[sunit]

I have table city
i want join all city in single row as group by as per requirement
if in visual i use country then show all city in one row as per country
if i use state then show all city in one row as per state

[Deep]

Hello Sunit,

I do not think ListAgg Function is yet available in QuickSight. If your data happened to be coming from backend you have do do that in the backend itself for example in Redshift

May be you could use Cascading filter in QuickSight but again it may not be in single row - see cascading filter here - example here

with you current requirement, in my opinion the Citylist would not look great if a certain state contains too many Cities and may distort the table structure. just my thought.

Hope the above gives you some idea and direction.

Thank you.
Cheers,
Deep

[sunit]

Thanks For Reply, for City List is just for Example, I need for other ,
if i get ListAgg from Query but after filter is not look like which i want.
i try sumover but its not applicable for string,
i am check with direct Query if Possible , but its slow,
in future ListAgg available in Quicksight calculate Filed?

[Deep]

Hello Sunit,

I have marked this as feature request.

Thank you.

Cheers,
Deep