Filter in kibana

Elastic Stack Kibana
1

hello,
I want to get the selected filter based on a single element in kibana to create pie visualized Browser.

Example :
I want make this:

select state : 0, state : 1, state : 2 from myTable were host_name = "SID";

Someone can help me please.
Thank you for your help.

2

Hi,

in the query bar you'll want to filter the result set:

(state: 0 OR state:1 OR state:2) AND host_name: SID

In visualize you would then do a terms aggregation on state.