How to dynamically change the dropdown menu of a dashboard as a result of selecting another dropdown?

[tmontney]

I have a processes dashboard, with two dropdown menus: Computer and Process Name. Not all computers have the same processes running, so I don't want to pull all possible processes (from all computers). If I select my computer, the process dropdown menu should repopulate. Unfortunately, I don't see that happening.

[gokadroid · Accepted solution]

If you want two dropdowns that should populate dynamically, then using the query within the dropdowns is an option. You have to have querywhich will populate the field , say,computerNamein first dropdown and then assign it tocomputer_nametoken. The second dropdown query then can use thiscomputer_tokento search and list all the fieldprocessName` and show it in second dropdown. Try something like below:

 <input type="dropdown" searchWhenChanged="true" token="computer_token">
      <label>Computers Dropdown</label>
      <choice value="*">All Computers</choice>
      <search>
        <query>index=yourIndex sourcetype=yourSourceType | stats count by computerName</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
      <fieldForLabel>computerName</fieldForLabel>
      <fieldForValue>computerName</fieldForValue>
    </input>
    <input type="dropdown" searchWhenChanged="true" token="process_token">
      <label>BackEnd</label>
      <choice value="*">All</choice>
      <search>
        <query>index=yourIndex sourcetype=yourSourceType computerName=$computer_token$ | stats count by ProcessName</query>
        <earliest>-24h</earliest>
        <latest>now</latest>
      </search>
      <fieldForLabel>ProcessName</fieldForLabel>
      <fieldForValue>ProcessName</fieldForValue>
    </input>

From here on, both $computer_token$ and $process_token$ can be used in a panel query to filter for any specific computerNmae and processName combination.

[tmontney]

You're simply saying to reference the computer token in my process query, right?

[gokadroid]

Yes, reference your computer token in process query and that should list the process corresponding to the computer which got selected.

[tmontney]

Weird. I had done just that before asking and I didn't see "populating". I came back to it after working on some other dashboards, and it seems to be working.