topic Re: Can you help me with my dropdown list show? in Dashboards & Visualizations

Can you help me with my dropdown list show?

SoknySplunk — Tue, 29 Sep 2020 21:07:59 GMT

I have two dropdown list related to each other.
- Dropdown_list 1= red, yellow, orange, blue…
- Dropdown_list 1= user_a, user_b, user_c, user_d
When I choose a colour in dropdown_list_1, I want dropdown_list_2 to show default all user who love that colour. ALL. Thanks your help.

Re: Can you help me with my dropdown list show?

kamlesh_vaghela — Tue, 04 Sep 2018 04:50:49 GMT

@SoknySplunk

How are you relating RED and user_a? Can you please provide more information regarding who love red color and who love yellow?

Re: Can you help me with my dropdown list show?

SoknySplunk — Tue, 29 Sep 2020 21:08:05 GMT

user_a like all color
user-b like red color
user_c like yellow and orange
user_d like blue.
thanks

Re: Can you help me with my dropdown list show?

harishalipaka — Tue, 04 Sep 2018 06:58:41 GMT

hi @SoknySplunk

try this code..

<form>
  <label>dropdown</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="colour">
      <label>colour</label>
      <fieldForLabel>colour</fieldForLabel>
      <fieldForValue>colour</fieldForValue>
      <search>
        <query>|makeresults |eval colour="red" ,user="user1" |append[|makeresults |eval colour="yellow" ,user="user2"] |append[|makeresults |eval colour="orange" ,user="user3"] |fields - _time</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
    <input type="dropdown" token="user">
      <label>user</label>
      <fieldForLabel>user</fieldForLabel>
      <fieldForValue>user</fieldForValue>
      <search>
        <query>|makeresults |eval colour="red" ,user="user1" |append[|makeresults |eval colour="yellow" ,user="user2"] |append[|makeresults |eval colour="orange" ,user="user3"] |fields - _time |where colour="$colour$"</query>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
    </input>
  </fieldset>
</form>

Re: Can you help me with my dropdown list show?

SoknySplunk — Tue, 29 Sep 2020 21:08:08 GMT

For example:
Field_color Field_user
red user_a
yellow user_b
orange user_c
blue user_d

If I choose blue in field_color, it should be show user_d only one in field_user
if i choose orange it should be show user_c only one in field_user

Re: Can you help me with my dropdown list show?

niketn — Tue, 04 Sep 2018 08:33:19 GMT

@SoknySplunk based on the requirement seems like you should setup a lookup file with Color to User mapping so that it becomes easy to maintain and correlate.

Re: Can you help me with my dropdown list show?

mstjohn_splunk — Tue, 04 Sep 2018 20:47:39 GMT

@SoknySplunk

Did you try @harishalipaka 's example? if it worked for you, please approve his answer. If not, go ahead and give us some more information so other community members know you still need help.

Thanks and happy Splunking!