Custom on/off filter to exclude multiple values in a field

Question & Answer
,
1

I would like to create a filter which excludes all rows where a field contains a specific set of values. The idea is to have a toggle to exclude or include rows with the specific values.

I typically use basic filter lists, or Custom Filters using a parameter linked to a dataset. I did some searching and saw a few hits that said this may not be possible, but wanted to get some input before I look for a different way to accomplish the end goal.

I believe I have seen something like this done in a dashboard from the AWS Workshop using a calculated field but I have not been able to find it. I’ll continue to look.

Thank you

2

Hi @csoderlund ,

welcome to the community :tada:

Have you tried a calculated field with multiple contains formulas connected with OR functions?

eg. ifelse( contains(state_nm , "New" ) or contains(state_nm , "Old", 1, 0 )

Then you exclude the 1.

Best regards,
Nico

If this helped you, please mark my answer as solution. That helpes the community to find solutions faster.

1 Like
3

I will give this a try. I believe this is the calculated field method I had seen but did not have an immediate example of.

Thank you

4

This worked. I modified the value if true/false to be meaningful descriptions for consumers of the dashboard.

Thank you

1 Like