Hi! I'm trying to filter on a concatenated field in an analytic app. The field that can be up to 4 values, example 1: "one, two, three, four", but the field can have less in any order, example 2: "one, four, three"
I would like the user to select which values (preferably in the list box format, see attached) and when the user selects the values it calculates similarly to a contains OR function.
For example if the user selects 'two' only example 1 would pass through the parameter but if the user selects 'one' and 'two' then both examples will be true.
Thanks!