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.