I have an index (index1) with that contains documents with a geo spatial boundary field and an associated area field. I have a second index (index2) that includes documents with a simple geopoint field.
I would like use the Maps app to do a simple calculation:
I want to do a count aggregation of the documents in index2 for each region in index1, then I would like the color scale for the regions on the map to be displayed as the ratio of Count/Region Area. Is there any good way to do this?
Things I have already tried:
- Scripted fields don't work because can only apply on a single index
- I tried to do this in a Vega visualization, with a bucket aggregation query but I am limited to only showing 10,000 region boundaries and I have more than 10,000
Thanks in advance!