https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336705#M99898 <P>Good to know! Thank you!</P> Fri, 28 Jul 2017 14:53:09 GMT sarahw3 2017-07-28T14:53:09Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336700#M99893 <P>I am trying to create a dropdown menu where a user can select a city. I have the following code as the search string but it is not working.<BR /> sourcetype="support_csv" location | fields location | dedup location</P> <P>I have very little experience with Splunk and need a basic how to for dropdown menus haha!</P> Fri, 28 Jul 2017 14:08:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336700#M99893 sarahw3 2017-07-28T14:08:39Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336701#M99894 <P>what about this:</P> <PRE><CODE>sourcetype="support_csv" |stats count by location|fields - count </CODE></PRE> <P>and then in your Field for Label and Field for Value, use location </P> Fri, 28 Jul 2017 14:16:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336701#M99894 cmerriman 2017-07-28T14:16:56Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336702#M99895 <P>Try the following for Dynamic Options of the dropdown:</P> <PRE><CODE>sourcetype="support_csv" location=* | dedup location | table location </CODE></PRE> Fri, 28 Jul 2017 14:26:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336702#M99895 niketn 2017-07-28T14:26:20Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336703#M99896 <P>That worked perfectly! Thank you so much!!</P> Fri, 28 Jul 2017 14:35:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336703#M99896 sarahw3 2017-07-28T14:35:22Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336704#M99897 <P>Like this:</P> <PRE><CODE> sourcetype="support_csv" |stats count by location|sort 0 - count | fields - count </CODE></PRE> <P>This puts the most popular locations at the top.</P> Fri, 28 Jul 2017 14:38:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336704#M99897 woodcock 2017-07-28T14:38:37Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336705#M99898 <P>Good to know! Thank you!</P> Fri, 28 Jul 2017 14:53:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-dropdown-menu/m-p/336705#M99898 sarahw3 2017-07-28T14:53:09Z