Drop-down

[Khuzair81]

DROPDOWN - I want to create one dashboard. While creating Country Dropdown I want only those countries in dropdown which my team support(US, UK, AUSTRALIA ETC.) but we are getting data for All countries.

Query - index=* country="US"  OR country="UK" OR country="AUSTRALIA" | table country | dedup country 

The above Query give me the perfect result in dropdown.

But I want to add one more option "All" in the dropdown which gives me the above mentioned country data only. Is there anyway?

[gcusello]

Hi @Khuzair81,

as @richgalloway, said, you have to add a static option ("All") not associating to it "*" as usual (beacuse in this way you take all the countries) but the list of the wanted countries, e.g.:

country="US"  OR country="UK" OR country="AUSTRALIA"

Ciao.

Giuseppe

[richgalloway]

A dashboard input can mix static and dynamic choices.  The dynamic choices are those produced by the query shown.  Add a static choice called "All" and give it a value ("*" is common) that works with your main query.