Using Separate Filters in a Dashboard as an OR type argument

Reply
Highlighted
Yellow Belt

Using Separate Filters in a Dashboard as an OR type argument

 Hi all,

I have a situation in which I have a High Roll-up of States grouped together and then a separate State level filter and want them to work together.  Example is: 

 

Region Filter: 

-East

-West

-South

-Midwest

 

And then a State Filter of all 50 states. 

 

I would like to have the have an option to pull in data that can include rows that satisfy either the Geographic OR the State filter.  So for example user selects "East" and then can also specifically select "California" in the State Filter.  Then the data has all the rows with Region = East and also the rows with State = "California".  Is this possible?  I'm using the Filter cards and applying it in the DOMO dashboard.  

Highlighted
Yellow Belt

Re: Using Separate Filters in a Dashboard as an OR type argument

Further note, what is going on is that when I select say "East" under the Region filter, I will then only be offered states to choose from on the East Coast in my State filter.  In a way, I don't want the Region filter to then dictates what's availble to select in the State filter.  

 

Thanks!! 

Highlighted
Black Belt

Re: Using Separate Filters in a Dashboard as an OR type argument

Unfortunately, the dashboard filters are set to work on an AND condition. Maybe not ideal, but you could could have one card that shows states totals and another card that shows region totals and have them sit next to each other in your dashboard. If you are using the filter cards, you can tell it which cards should be affected when the filter is applied.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Tags (1)
Yellow Belt

Re: Using Separate Filters in a Dashboard as an OR type argument

I've run into this myself in the past. One workaround I have used (though admittedly not the most elegant solution) is simply to CONCAT() the two filter fields together in Beast Mode.

 

This allows you to at least see the entire list of values when you filter. Super manual, but with a max list size of 50 values, it's not too tedious.

 

`Region - State` = CONCAT(`Region`, `State`)

----------
Serving up data insights since 2002...
Highlighted
Major Brown Belt

Re: Using Separate Filters in a Dashboard as an OR type argument

@MarkSnodgrass  and everyone else... stay tuned and check the next set of release notes ... there maaaaaay be a feature in the pipes that can help with your use case.  

 

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