I have a question regarding usage of multiple term join within a layer of Elastic Maps.
I have an index that stores the documents with geo_point location and some static values and other index with data that updates every 5 minutes. That second index gathers parameters of a network (cpu load, traffic outbound, traffic inbound...) but each parameter is stored as a unique document, I use 2 fields (parameter and value) to differentiate them.
My issue comes when using multiple term joins with filter for each parameter within a layer of the map, I'm capable of retrieving each value correctly if I use different aggregations for each parameter (average of value for parameter 1 and maximum value for parameter 2) but I can't use the same aggregation (average, for example) for both or I get the same value even though each layer is filtered and the values are completely different.
I can provide any additional information if it helps.
Thank you in advance.