topic Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3 in Dashboards & Visualizations

Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

ssroyer — Mon, 20 Jun 2022 17:20:10 GMT

I have multiple dropdowns with numerous (some 40+) selections per dropdown. What I would like to do is create a "Common KPI" dropdown with 3 choices to drive selections in the other dropdowns. I can make this work for a single value but not when there are multi-select values.

For example:

Common KPI dropdown - Choice "1" would select the following:

Dropdown 2 selections: Apple, Banana
Dropdown 3 selection: Golf

Common KPI dropdown - Choice "2" would select the following:

Dropdown 2 selection: Charlie
Dropdown 3 selections: Echo, Foxtrot, Hotel

<fieldset submitButton="false"> <input type="dropdown" searchWhenChanged="true"> <label>Dropdown 1</label> <choice value="1">1</choice> <choice value="2">2</choice> <default></default> </input> <input type="multiselect" searchWhenChanged="true" token="bar"> <label>Dropdown 2</label> <choice value="a">Alpha</choice> <choice value="b">Bravo</choice> <choice value="c">Charlie</choice> <choice value="d">Delta</choice> <default></default> </input> <input type="multiselect" searchWhenChanged="true" token="foo"> <label>Dropdown 3</label> <choice value="e">Echo</choice> <choice value="f">Foxtrot</choice> <choice value="g">Golf</choice> <choice value="h">Hotel</choice> </input> </fieldset>

Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

VatsalJagani — Mon, 20 Jun 2022 18:48:53 GMT

@ssroyer - You can have a common KPI input in simple XML like this:

<fieldset submitButton="false"> <input type="dropdown" searchWhenChanged="true"> <label>Common KPI Dropdown 1</label> <choice value="1">Alpha - Echo</choice> <choice value="2">Delta - Hotel</choice> <default></default> <change> <condition label="Alpha - Echo"> <set token="bar">Alpha</set> <set token="foo">Echo</set> </condition> <condition label="Delta - Hotel"> <set token="bar">Delta</set> <set token="foo">Hotel</set> </condition> </change> </input> <input type="multiselect" searchWhenChanged="true" token="bar"> <label>Dropdown 2</label> <choice value="a">Alpha</choice> <choice value="b">Bravo</choice> <choice value="c">Charlie</choice> <choice value="d">Delta</choice> <default></default> </input> <input type="multiselect" searchWhenChanged="true" token="foo"> <label>Dropdown 3</label> <choice value="e">Echo</choice> <choice value="f">Foxtrot</choice> <choice value="g">Golf</choice> <choice value="h">Hotel</choice> </input> </fieldset>

FYI, you can use <eval> instead of <set>, if you have dynamic values instead of static values.

I hope this helps!!!

Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

ssroyer — Tue, 21 Jun 2022 13:53:28 GMT

@VatsalJagani Thank you for the response. Your suggestion is working when only one value per dropdown needs to be selected. The part I'm having trouble with is when I need to select two or more options per dropdown. Example:

Common KPI - Option 1
Dropdown 1 - Alpha and Bravo <---- how do I get both options to set using the same token?
Dropdown 2 - Echo

Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

VatsalJagani — Tue, 21 Jun 2022 14:05:29 GMT

@ssroyer - The multiselect inputs generally have the following 5 properties defined, which tell what will be the value of the input.

(I've just assumed the values here, but you could put them as per your use-cases.)

And then you can update your inputs to something like this.

<fieldset submitButton="false"> <input type="dropdown" searchWhenChanged="true"> <label>Common KPI Dropdown 1</label> <choice value="1">Alpha-Bravo - Echo</choice> <choice value="2">Delta - Hotel</choice> <default></default> <change> <condition label="Alpha-Bravo - Echo"> <set token="bar">("Alpha", "Bravo")</set> <set token="foo">Echo</set> </condition> <condition label="Delta - Hotel"> <set token="bar">Delta</set> <set token="foo">Hotel</set> </condition> </change> </input> <input type="multiselect" searchWhenChanged="true" token="bar"> <label>Dropdown 2</label> <choice value="a">Alpha</choice> <choice value="b">Bravo</choice> <choice value="c">Charlie</choice> <choice value="d">Delta</choice> <default></default> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>"</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter>, </delimiter> </input> <input type="multiselect" searchWhenChanged="true" token="foo"> <label>Dropdown 3</label> <choice value="e">Echo</choice> <choice value="f">Foxtrot</choice> <choice value="g">Golf</choice> <choice value="h">Hotel</choice> </input> </fieldset>

You could repeat the same thing if you want for Dropdown 3.

I hope this helps!!!

Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

ssroyer — Tue, 21 Jun 2022 14:28:19 GMT

@VatsalJagani I am using a metrics index with mstats. I don't have prefix, suffix, or delimiters set in my multiselect. However, even when I do set them, in your example if I select "Alpha-Bravo - Echo" the selection in Dropdown 2 is all together ("Alpha", "Bravo") vs. two independent selections.

<form theme="dark"> <label>Dependent Dropdown</label> <fieldset submitButton="false"> <input type="dropdown" searchWhenChanged="true"> <label>Common KPI Dropdown 1</label> <choice value="1">Alpha-Bravo - Echo</choice> <choice value="2">Delta - Hotel</choice> <default></default> <change> <condition label="Alpha-Bravo - Echo"> <set token="form.bar">("Alpha", "Bravo")</set> <set token="form.foo">Echo</set> </condition> <condition label="Delta - Hotel"> <set token="form.bar">Delta</set> <set token="form.foo">Hotel</set> </condition> </change> </input> <input type="multiselect" searchWhenChanged="true" token="bar"> <label>Dropdown 2</label> <choice value="a">Alpha</choice> <choice value="b">Bravo</choice> <choice value="c">Charlie</choice> <choice value="d">Delta</choice> <prefix>(</prefix> <suffix>)</suffix> <valuePrefix>"</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter>, </delimiter> </input> <input type="multiselect" searchWhenChanged="true" token="foo"> <label>Dropdown 3</label> <choice value="e">Echo</choice> <choice value="f">Foxtrot</choice> <choice value="g">Golf</choice> <choice value="h">Hotel</choice> </input> </fieldset> </form>

Re: Dependent Dropdowns - Single selection from Dropdown 1 to select multiple values in Dropdown 2 and 3

VatsalJagani — Wed, 22 Jun 2022 08:14:47 GMT

@ssroyer - I felt like it used to work but it's not working anymore.

Surely, I gave this answer for the multi-select token in 2019, not sure which Splunk version.

https://community.splunk.com/t5/Dashboards-Visualizations/How-to-set-multiple-values-for-a-multi-select-input/m-p/436125

Now your best guess is to use JavaScript to manipulate tokens - https://dev.splunk.com/enterprise/docs/developapps/visualizedata/simplexmlextensions/tokenmanipulation/

Look for two main things, if you have never explored Splunk JS for tokens:
- token -> on change event (similar to <change> from XML)
- defaultTokenModel.set
- Make sure to set both defaultTokenModel and submittedTokenModel.
- submittedTokenModel

I hope this helps!!!