Geo map - "Group by" Dot walk fields are grayed out

[Hari1]

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

[Ankur Bawiskar]

@Hari1 

are you able to add group by on other dot walked field?

may be there is a platform limitation that you cannot add group by on dot walked field based on some field type

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Hari1]

@Ankur Bawiskar I am able to see all the fields are grayed out except the location field. Dot walk from Location->Country Name (Not able to select Country Name field) When clicked on Country name i see "Analytics Consent Policy". Please refer to the below snapshot

[Ankur Bawiskar]

@Hari1 

are you able to add group by on other dot walked field?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Hari1]

@Ankur BawiskarNo i am not able to when i do dot walk to select a field i see "Analytics Consent Policy" as per the screenshot. I need to add the location -> country name