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!!
... View more