Multi-select (OR) dashboard filtering

[vikrim1]

Hi, I'd like to allow business users of our dashboard to select multiple values from a graph/table to filter the dashboard by. Unlike the current behavior, the filters would have an OR relationship instead of AND. For example if I have two rows in a table, one with ID=1 and one with ID=2, I'd like to be able to check both of those and have the dashboard filter for ID=1 OR ID=2.

[abhijitdeka11]

Eagerly looking out for this feature. In our use case we would like to have multiple products selected in the query.Like Product= "P1" OR Product = "P2".Currently it's not straightforward.If possible can you please attach some milestone also for this enhancement.

[Miksunen]

This is definitely a must-have-feature.

[Miksunen]

Let's take a very common situation: A dashboard, which contains a visualization that shows a country of origin.

For our business users it should be really easy to select a subset of countries from that one visualization (for example all Nordic countries) ... and immediately see other visualizations show statistics about that subset.

Now the only way is to add all countries in the search query with OR between them. That's not intuitive.

Sure, I understand that OR also requires a possibility to add parenthesis between filters... But I trust you could soon come up with a neat UI solution for that.

[chenryn]

+1.

[andreyplotkin]

+1

[jnbala]

+1

[kevin1obrien]

+1

[acommendador]

+1

[cjstone]

+1

[harsjain]

This is must to have requirement. Can someone please tell, when can we expect this feature?

[ErwanPigneul]

+1

[chlaudon]

Although having this feature implemented in dashboards is key, it might be good to generalize it to other views (Discover, Visualize).

• For Dashboards, we could imagine using Shift-Click to select a value that needs to take part in the OR filter and once all values have been selected, run the the filter by clicking 'Apply'.
• For the Discover view, we probably need a third option besides +/- in the field value lists that would provide the same functionality while also showing that a value is part of an OR filter (some sort of radio button). In contrast to positive/negative filters, OR filters in the Discover view should not cause the removal of values that aren't part of the OR filter or else it would be impossible to add other values after the fact (they would not show). This may mean heavy work.

In both cases the values included in the OR filter would need to be displayed in the filter bar with a new color (green=positive, red=negative, yellow/orange=OR?) and grouped to make it easier to deactivate, negate or set the main operator:

• AND( x OR y) for filtering
• OR (x OR y) for promoting

[jccq]

Ping about this feature (how about a P2? :)) )

How about this

1. one presses a spacial key (shift?) and Kibana filter bar shows up in "OR MODE COMPOSABLE FILTER" . For touch UI this could be a long keypress on a slice having the same effect.

2. at this point (e.h. while the key is pressed) each click will NOT generate a refresh but rather add a filter to the OR MODE COMPOSABLE FILTER space" , e.g. nationality = IT or Fr or US etc..

3. Upon releasing of the key (or pressing apply in the OR MODE COMPOSABLE FILTER SPACE for touch interfaces ) the OR bar disappears leaving instead a "compiled" :) or filter which acts like any other

would this make sense?

[eamonngryan]

+1

[IngaFeick]

+1

[pemontto]

👍

[haizaar]

Yet another +1!

[ktarasz]

+1

[svenmueller]

worth adding one more +1

[morberg]

+1

[martinsbalodis]

+1

[michimau]

+1

[mitch99]

+1
Agree with Miksunen above, search field queries are too complex for end users. This feature would really make a difference in usability and put Kibana as a realistic alternative to for example basic Excel & Tableau dashboards.

[eltondsouza]

+1

[Sandy381]

+1

[Sandy381]

Atleast if they tell how to pass multiple values in an URL it will be useful.

[fglendrange]

+1

[ppisljar]

this is being worked on and tracked here: #127247

[elasticmachine]

Pinging @elastic/kibana-data-discovery (Team:DataDiscovery)

[stratoula]

Currently you can create OR filters for XY charts, we plan to offer more advanced filtering capabilities to other charts and we are tracking this here #150304
I am closing this as we track this request on the aforementioned issue

You can now create OR filters on the dashboard level from the filter builder

[jughosta]

As @ppisljar mentioned, the filters UI was also extended to provide more options