What I want to do is if a user selects "Agency" in the first dropdown box then he should be shown only "Not defined" option in the 2nd drop down box rather than showing all the areas. Any idea on how to do it.
Also, I have a search box listed in the fieldset. I was wondering if there is any way to prioritize the searches over the dropdown box. I mean to say, if a user (Business Analyst) give a Worgroup as 1234 then irrespective of what's listed in the dropdown boxes the output has to be of that WG. Any idea if this would be possible?
Have you thought to use dynamic option to populating second dropdown? Because when I want filter which second dropdown should be shown, after create the populating search to second dropdown, I add the token from first dropdown to filter the search. If you are using splunk 6.1 or more, you can found an exemple: