Creating a dashboard with 3 independent dropdowns (country,state,city). The ideas is for the user to select or more of the dropdowns and based on the selection it will populate a table.
For example, if the user selects only the country dropdown (lets say United States) then the other 2 dropdowns will default to selecting all.
When creating the search for the table and passing the value for the country is simple, my question is for the other two fields, is it possible to do the following or something similar:
| where country ="United States", state=ALL, city=ALL
Any help or guidance would be appreciated!!
you can either set the default value to "*", or you can have the input/dropdown use a prefix to the field value. if there is no field value selected at all, then the prefix will also be omitted, so the term will not even exist in your search template.