Using delimiter separated field as filter

Question & Answer
, ,
1

Greetings,
In my product, I am collecting data using multiselect and the data is being stored in a field using comma as separator. Now I want to use this field as a filter so that the user can see statistics for rows that have at least one selected value. Is there any way I can do this.
Thanks in advance.

2

Hi @Raghu ,

You can achieve this by creating parameter in QuickSight and use the same parameter control as a filter. Put your default parameter value so that it always so you default filter value.

Thanks & Regards
Biswajit Dash

1 Like
3

@Biswajit_1993 Is it possible to convert those comma separated values into array using calculated field?

4

Hi @Raghu yes you can do that by using split() in QuickSight.

Thanks & Regards
Biswajit Dash

1 Like