Dashboards & Visualizations

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

tmontney
Builder

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.

0 Karma
1 Solution

gokadroid
Motivator

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.

View solution in original post

gokadroid
Motivator

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
Builder

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

0 Karma

gokadroid
Motivator

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

0 Karma

tmontney
Builder

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.

0 Karma
Get Updates on the Splunk Community!

How I Instrumented a Rust Application Without Knowing Rust

As a technical writer, I often have to edit or create code snippets for Splunk's distributions of ...

Splunk Community Platform Survey

Hey Splunk Community, Starting today, the community platform may prompt you to participate in a survey. The ...

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...