Wondering if someone can shed some light on whether I'm trying to do the impossible in Kibana
I'll use example images for the purposes of this post.
The following image shows a number of geographical locations across London. These are contained within an index (we'll call this 'locations' index) as a number of documents, each with their own geo_point field containing the location.
Similar to what has been demonstrated here (https://blog.mimacom.com/custom-region-map/), I want to portray these locations as a custom region map in Kibana.
As per the blog post, I've created my own geoJSON file using http://geojson.io/
The geoJSON file contains 4 regions within London, and once uploaded to Kibana (within a new map visualisation), it looks like this -
By uploading the geoJSON file, it automatically creates an index containing the geo-points that make up the 4 regions. We'll call this index 'regions'.
My question is, is it possible to join the 'locations' index with the 'regions' index somehow, and change the colour of each region based on the number of locations contained within it? For example, in my example it's clear the top right region contains the most locations, so this would be a darker red. The lower left region containing the least would be yellow (colours don't matter, it's the scaling I'm interesting in).
My worry is that I can only join the two indexes based on terms, but I don't have any terms defined in the geoJSON file, and therefore there are no terms defined in the regions index.
Any thoughts/ideas aere very welcome!