https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405526#M6990 <P>I am trying to build a dashboard with a table that can be navigated with the dropdown menu.</P> <P>This is the query for my table: </P> <PRE><CODE>`source="LMCustomerRevLicense.csv" | dedup "Account Name" | table "Account Name" "Total Active Subscription Revenue _converted"` </CODE></PRE> <P>What would the search token, search query need to be for the dropdown to search off the Account Names?</P> Wed, 27 Jun 2018 16:53:08 GMT Ragate 2018-06-27T16:53:08Z https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405526#M6990 <P>I am trying to build a dashboard with a table that can be navigated with the dropdown menu.</P> <P>This is the query for my table: </P> <PRE><CODE>`source="LMCustomerRevLicense.csv" | dedup "Account Name" | table "Account Name" "Total Active Subscription Revenue _converted"` </CODE></PRE> <P>What would the search token, search query need to be for the dropdown to search off the Account Names?</P> Wed, 27 Jun 2018 16:53:08 GMT https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405526#M6990 Ragate 2018-06-27T16:53:08Z https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405527#M6991 <P>Hey Ragate,</P> <P>Depending on what you set the token value to when creating the drop down you need to add the token into your search like so:</P> <PRE><CODE> `source="LMCustomerRevLicense.csv" $field_tok$ | dedup "Account Name" | table "Account Name" "Total Active Subscription Revenue _converted"` </CODE></PRE> <P>Reference: <A href="http://docs.splunk.com/Documentation/Splunk/7.1.1/Viz/tokens">http://docs.splunk.com/Documentation/Splunk/7.1.1/Viz/tokens</A></P> Wed, 27 Jun 2018 19:12:08 GMT https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405527#M6991 hos_2 2018-06-27T19:12:08Z https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405528#M6992 <P>Thank You!</P> Wed, 27 Jun 2018 19:34:15 GMT https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405528#M6992 Ragate 2018-06-27T19:34:15Z https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405529#M6993 <P>Dont forget to mark this as the answer</P> Thu, 28 Jun 2018 09:57:27 GMT https://community.splunk.com/t5/Splunk-Dev/How-do-I-develop-a-search-query-for-my-dropdown-to-sync-with-my/m-p/405529#M6993 Moreilly97 2018-06-28T09:57:27Z