How to plot choropleth data on maps? I have data from multi-cloud in respective index.

[sh254087]

I am trying to understand how I can plot my multi-cloud subscription/service consumption data from different geo regions, on a clustered choropleth map visualization.

I have multi-cloud subscriptions with services provisioned and consumed from different regions. 

I want to know where to start with - from reading articles and documentation, I understand I should have longitude, latitude information in my data for each of the regions that I want to plot data for(at least, if not for all). None of my CSP data in respective indexes have this information. If I have to come up with a CSV, unsure  how I'll link them to get this to working. 

Anyone came across similar use-case?

Any help would be appreciated.

[ITWhisperer]

If you have a csv with the information, you can use lookup with a suitable key to retrieve the data relevant to each event

[sh254087]

To keep it simpler, just trying with AWS cloud, to begin with.

Here's how my region_coordinates.csv which has the region, latitude and longitude and other fields looks like -

I have services and their respective cost consumption data which looks like this (on a trellis-pie visualization, just used this to convey better)- 

I am trying to get thispie visualization on a map something like this - (referring to 'sample dashboard example' app) - 

Tried geom and geostats command but did not get expected output.

[sh254087]

I have the cloud consumption information indexed in real-time. I do not (or can not) have the consumption information in a csv. I want this map to showcase the cloud consumption data across different regions in real-time. I can come up with a csv having long and lat values for each cloud-regions. I'm unsure how to link these two to come up with the map visualization.