Skip to main content

Visualizing Geographical Data in Reports

  • May 5, 2020
  • 5 replies
  • 98 views

GarethR
  • Contributor ⭐️⭐️⭐️

I've been working on some visualizations of customer data recently and wanted to create a visualization of customers by country and found there isn't really a nice way to do that.

 

I tried a pie chart but it looks like a mess. I also tried the packed bubble visualization, which could be ok but doesn't take up all the space in the report area so is super difficult to read. Screenshot attached to show you what I mean (there’s really a lot of unused space when I use this visualization).

 

It would be really cool if there was a map visualization, like in every other BI tool that I've used in the past. This would make visualizing geographical data much easier to read.

 

5 replies

rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • May 26, 2020

Hi Gareth,

In order to display customers by country on a map, we need to first understand the locations in the data. Unfortunately, we do not understand or can guarantee that in the data today, considering that country name is a generic string field. We explored to handle this in reporting but were unable to map accurately for multiple scenarios here. 

cc: @pgeorge → Do you think we could enhance our data platform for a location? Say latitude, longitude, etc?


GarethR
  • Author
  • Contributor ⭐️⭐️⭐️
  • May 26, 2020

Thanks, Rakesh.  When I worked with Tableau, I was able to input Latitude and Longitude values for the locations, and then it was displayed on a map so I think this would be a valid solution in Gainsight also.


pgeorge
Forum|alt.badge.img+1
  • Gainsight Employee ⭐️
  • May 26, 2020

@rakesh Will look into this.

We could ship Standard Dropdown items that could be mapped to Geographical regions

 


pope1chase
Forum|alt.badge.img+2
  • Helper ⭐️
  • November 2, 2021

Hi @pgeorge and @rakesh. Any chance this has been added to the roadmap? I recently received requirements for a report of this nature and could see other benefits from this. 


pgeorge
Forum|alt.badge.img+1
  • Gainsight Employee ⭐️
  • November 10, 2021

Hi @pope1chase 

We have not yet started the analysis on this.

We will keep you informed on the updates

Thank you 

Preethi