India map data visu not considering latitude and longitude, instead taking City to group

[dss]

Hi,

I am working on data visualization, where based on customer I have selected in Interactive filter, I should see devices mapped to customer in India Map.

Now, India Map is working fine and device count as per city is also correct.

Issue is: in cmn_location table, Mumbai BKC, Mumbai Churchgate, Mumbai Borivali have different latitude and longitude. In india map, these 3 locations should be visible separately.

Instead of this, single Mumbai location is visible and showing device count.

Customer wants 3 different locations should be visible as all have different latitude n longitude.

please help.

[Dr Atul G- LNG]

any screenshot?

I think the filter condition needs to be changed. It looks like you’re filtering on the City field, whereas I think the filter should be applied to the Location Name field.

[dss]

Hi Atul,

Thanks for the reply.

I have added one extra level to the Location mapping in the table viz_map_source and it started working as desired

but then in platform analytics data visualization, drilling down on GeoMap is not possible.

So I have to move to classic report to configure the report. But not sure how long classic reports will be supported.

[Dr Atul G- LNG]

Hi @dss 

Logged a case with Now support regarding GeoMap,  The legacy report is available until the end of 2027.

[dss]

Hi Atul,

Thanks for the reply. Let me know what response you get from ServiceNow on your case.

Thanks