Maps: Doing simple math on a region Aggregation

Elastic Stack Kibana
1

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:

  1. Scripted fields don't work because can only apply on a single index
  2. 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!

2

Hello,

Dynamic color ranges in the Maps App aren't possible yet. There is however a PR in progress along with some relevant linked issues.

Regards,
Aaron

3

Thanks Aaron, this actually isn't really what I'm looking for. The part that is hard is to do basic math in the aggregation query within a Kibana Map or other type of Visualization

For example a Count aggregation where the result is divided by a constant can easily be done that way, but then I have no way to display the result unless I build a custom Vega visualization

In the case described above a Vega map would be a fine solution, however, since the query is limited to 10000 results I can't do it easily. Maps would be a great solution, but I don't think there is any way to do this?