topic Re: Drop-down in Getting Data In

Drop-down

Khuzair81 — Sun, 16 May 2021 22:47:05 GMT

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?

Re: Drop-down

richgalloway — Mon, 17 May 2021 00:01:31 GMT

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.

Re: Drop-down

gcusello — Mon, 17 May 2021 06:09:52 GMT

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