Page filter with multiple selections

[TylerT]

Hello,

Is there a page filter that has multiple pull down filters on the same card?  Something like this...

Or, if not, what is the best approximate alternative?

Thank you,

Tyler

[AkshayHarshe]

Hi @TylerT 

Insights shines at interactive and exploratory analysis. I will encourage you to think about different ways of filtering and explore your analysis using combinations of filters available, such as the Filter widget (a predefined filter if you are using <2023.3), cross filters, card filters, and advanced card filters. 

I am assuming all the columns in your screenshot above are coming from the same dataset. If so, it is best to use charts and graphs for broader categories. e.g. 

1. There could be a filter widget configured for the year drop-down.
2. "Current Week" Could be a filter widget with advanced filter with expression `DATEDIFF(DATE,NOW(),"D") <7`
3. A heat map or stacked bar chart could represent the organization market and submarket, while Global and domestic account name columns could be summary or reference tables. Cards enabled with cross filters will dynamically update when clicked on ther related cards.

Hope that helps.

[TylerT]

That screen shot was just an example of the style of filter I'm looking for, a series of pull down filters.  For simplicity sake, can I put two pull down filters on one filter card or are they going to be total separate filters/cards as shown below?

Thank you,

Tyler

[AkshayHarshe · Accepted solution]

Hi Tyler, 

Apologies; I misinterpreted your question. We don't have a style similar to that. but you can make it look like that.

• On every card, the small carret icon will hide the header that says Fitler 1 and 2.
• The filter widget can be configured to hide the include, exclude, and reset buttons.
• Set the border style to none
  • 
• Remove the Card background color and resize the cards
• Finally, create a text and media widget add add text for your headers. to achieve somethign like this:

Hope that helps.

[AJ_devaccount]

hi @AkshayHarshe , thanks for showing us how to achieve this look! Do all the filters togther work as AND or OR filters?

[AkshayHarshe]

@AJ_devaccount My pleasure. If all the filters are pointing to the fields in the same dataset they will work as "AND". That said, they are not Drill down filters, meaning, if filter 1 is set to "STATE" and filter 2 is set to "City" column of a dataset then filtering to STATE of California will not filter out those records from the Filter 2 display. All the cities will still be displayed. In this case you can use other cards such as Summary table along with cross filter to further filter your analysis.

[AJ_devaccount]

Thanks!