topic Re: how to pass static dropdown value to a second static dropdown in Dashboards & Visualizations

how to pass static dropdown value to a second static dropdown

guillecasco — Mon, 13 Jun 2016 21:04:45 GMT

i tried to do this with querys to populate each dropdown but i´m getting some errors. I just want to have this manually like this:

Dropdown 1
A
B
C

dropdown 2
123
234
345
456

if i choose A i just want to show on other dropdown: 123 and 234 (for example)
if i choose B i just want to show 345 and 123
if i choose C 123,234 and456...and so on

is there a way to do this manually? there are not so many values and i don´t mind adding them . Is there some kind of "eval" with dropdowns?

Thanks

Re: how to pass static dropdown value to a second static dropdown

sundareshr — Tue, 14 Jun 2016 20:41:46 GMT

@guillecasco,

An easier approach would be use a query to populate your second dropdown. The query for the second dropdown can use token value from the first drop down to filter appropriately.

http://docs.splunk.com/Documentation/Splunk/6.4.1/Viz/tokens#Define_tokens_for_form_inputs

Re: how to pass static dropdown value to a second static dropdown

somesoni2 — Tue, 14 Jun 2016 20:52:33 GMT

Try this

1) Create a lookup table, say dropdownvalues.csv, with two columns field1 field2 **choose good names if possible for both lookup and columns
dropdownvalues.csv

 field1,field2
A,123
A,234
B,345
B,123
C,123.
C,234
C,456

2) Dropdown 1, use this query (assuming token name is field1)

| inputlookup dropdownvalues.csv | stats count by field1 | table field1

3) Dropdown 2, use this query

| inputlookup dropdownvalues.csv | search field1="$field1$"| stats count by field2 | table field2

Re: how to pass static dropdown value to a second static dropdown

guillecasco — Tue, 14 Jun 2016 21:09:04 GMT

thanks man!

Re: how to pass static dropdown value to a second static dropdown

guillecasco — Tue, 14 Jun 2016 21:09:11 GMT

thanks man, it was easier to get the values on the second drop box dynamically from a search.
Will implement you idea when i can´t do that.