I have 2 drop-downs in a form on a dashboard. Based on what i select in the first drop-down, I want it to dictate the values in the 2nd drop-down. How can this be done? any examples, suggestions available?
Form examples show how to populate data dynamically. But in my case, dropdown values are static only. for example when i select first value from first dropdown, all values from 2nd dropdown are applicable. But when i select 2nd value from first drop down, only subset of values from 2nd dropdown are applicable. Do you know how to achieve this?
Same basic strategy, just with a small detour.
Define your first dropdown static as you normally would.
Define your second dropdown dynamic with a search like this:
| stats count | eval values = "one two three four five" | makemv values | mvexpand values
That gives you a static list of five values. You can now append filters based on your first value like this:
... | where "$firstvalue$"="foo" OR values="one" OR values="two" OR values="three"
That would keep all values if the first selected value is
"foo", and keep only the first three values if it's not.