Hi,
I have a requirement to create a geo map data visualization in UI Builder. I am able to add the table for the data source but when i want to select the group by dot walk to location.country_name I am not able to do the dot walk as the country_name field is greyed out and i am not able to select it. Any help on how do we select the field country_name?
If I select only the field location i am not able to get all the location data. As the report pop-up a error message stating - "Some of the data you selected cannot be visualized on the map due to mapping errors. View records". When i click on the View record. Below is what is see on the filter.
From the backend the cmn_location table key values has India, Australia, But the Location.Country has IND, AUS, GBR. Which is causing the error.
When i try to do the dot walk. Location.Country Name I am not able to as the field is grayed out.
Country Name has the values like India, Australia which aligns with the cmn_location table data
Any help?
Thanks
