Filtering Multiple Values in One Column with Match Values

Reply
Highlighted
White Belt

Filtering Multiple Values in One Column with Match Values

When filtering with Match Values as in the screenshot below, does Domo intuitively understand that these are all individual things to filter out? I cannot use a selection filter in my case because the values are not currently in the data but may be included in the future.

filter.png

 


Accepted Solutions
Highlighted
Black Belt

Re: Filtering Multiple Values in One Column with Match Values

You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this:

(CASE when TRIM(`City`) = 'Abbeville' then 1
when TRIM(`City`) = 'Phoenix' then 1
when TRIM(`City`) ='Albany' then 1
else 0
end)

You would then drag your new beast mode field into the filters and select the 1 or Y or whatever you decided on to only show those values. This keeps it from being tied to matching existing values in your dataset.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)

All Replies
Highlighted
Black Belt

Re: Filtering Multiple Values in One Column with Match Values

You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this:

(CASE when TRIM(`City`) = 'Abbeville' then 1
when TRIM(`City`) = 'Phoenix' then 1
when TRIM(`City`) ='Albany' then 1
else 0
end)

You would then drag your new beast mode field into the filters and select the 1 or Y or whatever you decided on to only show those values. This keeps it from being tied to matching existing values in your dataset.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Tags (2)
Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!