Dashboards & Visualizations

Populate dropdown based on previous dropdown value

k_harini
Communicator

I'm able to populate dropdown based on previous dropdown value with passing that token. But when ALL is selected in previous dropdown , i want "ALL" to appear in dependent dropdown without any values. Only when some value is selected, other dropdown should refresh accordingly.

How to achieve that.. ?

Tags (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi k_harini,
I don't know how is written your dropdown, but I think that in the first one you have ALL ("") as default value and you pass the choosen value (a single value or "") to the second one.
In the second dashboard, I think that you use the first dropdown choice as a filter in the search (e.g.: mysearch $token$), and you have ALL ("*") as default value.
In this way, if you have ALL in the first dropdown, you have ALL also in the second one, if instead you choose a value in the first dropdawn, you have in the second one the possibility to choose both ALL or a single value.
In other word something like this:

<input type="dropdown" token="My1" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag | dedup SS | table My1 | sort My1 </query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My1</fieldForLabel>
  <fieldForValue>My1</fieldForValue>
  <default>*</default>
  <prefix>My1="</prefix>
  <suffix>"</suffix>
</input>
<input type="dropdown" token="My2" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag $My1$| dedup My2 | table My2 | sort My2</query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My2</fieldForLabel>
  <fieldForValue>My2</fieldForValue>
  <default>*</default>
  <prefix>My2="</prefix>
  <suffix>"</suffix>
</input>

Bye.
Giuseppe

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi k_harini,
I don't know how is written your dropdown, but I think that in the first one you have ALL ("") as default value and you pass the choosen value (a single value or "") to the second one.
In the second dashboard, I think that you use the first dropdown choice as a filter in the search (e.g.: mysearch $token$), and you have ALL ("*") as default value.
In this way, if you have ALL in the first dropdown, you have ALL also in the second one, if instead you choose a value in the first dropdawn, you have in the second one the possibility to choose both ALL or a single value.
In other word something like this:

<input type="dropdown" token="My1" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag | dedup SS | table My1 | sort My1 </query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My1</fieldForLabel>
  <fieldForValue>My1</fieldForValue>
  <default>*</default>
  <prefix>My1="</prefix>
  <suffix>"</suffix>
</input>
<input type="dropdown" token="My2" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag $My1$| dedup My2 | table My2 | sort My2</query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My2</fieldForLabel>
  <fieldForValue>My2</fieldForValue>
  <default>*</default>
  <prefix>My2="</prefix>
  <suffix>"</suffix>
</input>

Bye.
Giuseppe

0 Karma

k_harini
Communicator

Thank you so much for your response and the code. I tried this.. Even then All values are getting populated wen i select 'All' in first drop down.. I just want to display 'All' and user should not have the ability to select other values from second drop down.

0 Karma
Get Updates on the Splunk Community!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...