Dynamic Drop down item is not picked up in the statistics table

[splunkambarish]

I have created a dropdown menu and statuistics table but the query i have added up in the source as base query and pulled it for all the content in the dashboard

base query is pointed for dropdown

Base query is pointed for statistics table

so now both the data is almost same , so where i see the data in the Dropdown which is distinct & loaded dynamically by the results of base query . this value has key country words like "United States" which is not being picked up by statistics table

but the same is working fine when i give "Unitedstates" which is without SPACE in the word.

Any one has any suggestions.?

[woodcock]

Have you tried token filters (maybe the |n)?
https://docs.splunk.com/Documentation/Splunk/latest/Viz/tokens#Token_filters
https://docs.splunk.com/Documentation/Splunk/latest/Viz/tokens#Define_token_filtering_and_formatting

Also try putting your token reference inside of double-quotes.

[gcusello]

Hi splunkambarish,
could you share your source?
Bye.
Giuseppe