Hi, I'm using ArcGIS Experience Builder filter widget to be used on a single column of data which has the text of survey question answers from 4 separate columns concantenated into a single string, each response from each column is separated by a spacebar. In the filter box in EB I would like the box to contain a list of all possible answers - a single item next to each tick box - to make it look tidy, rather than a concatenated string which appears when the data is loaded. Thus when the user selects 'yes' the map would filter all those points which contain 'yes'. For example yes for the first question and the other 3 questions are blank, then scenario 2 yes yes no no, then scenario 3 blank, yes, blank blank etc. Is this possible with the SQL 'contains' statement in EB, or could there be a work around to this? And also an option to include a single unique item in the filter box, even though in the data it appears as part of a string?
