Better visualisation for comma seperated values

[harpson]

Hi @avanni ,
Thanks for reaching out, You can refer below link and check the solutions:

How to use values from a list aggregated field in a table to a filter in Quicksight?

I have a dashboard in Quick-sight where a table is being used which contains a field that has values list aggregated.(Please refer the attached image). I need to create a filter in a dashboard that will have a dropdown with distinct values from the list aggregated values so that if i select/check a particular value from a dropdown then it should filter out the list aggregated record by matching the string i selected in a drop down. I tried to use the split function to get the distinct values f…

Alternatively, You will need to perform this transformation in another tool. Take a look at AWS Glue Databrew or AWS Glue Studio if you cannot use custom SQL for it.

Thank You