Hi - I am a newbie to elasticsearch and maps, so sorry if this is an obvious question but I cannot seem to find much info on detailed examples. This is my issue:
I am trying to visualise the status of our HW units around the US on a map, with a colored circle representing the status of each unit. Colors indicate status: Green="working", Amber="unknown", Red="not working". I have managed to get it working by mapping a number 0,1 or 2 to a numeric status field returned by each unit and then using a Document Query layer on the map. This works - I get colored circles for each unit.
The problem is that several units may have the same location, which maps then seems to aggregate - when I hover over a point I see there are a number of "features" at that point. That is fine, but I need the colored circle to show the worse-case state of any of these aggreagted units i.e. the unit with the highest numbered state and color the circle accordingly. So, for example, if 4 units have been aggregated and there are 3 working and 1 not-working, I want the circle color to be red. But so far, the selected color seems to be randomly selected amongst the returned results so in this example, may be green or red.
Is there a way to construct a query in maps to do this? Or, is there a way to use multiple layers to achieve something similar? I have tried to use the latter approach, with a different filter for each layer, but I cannot seem to get it to accept a layer -specific filter, it ignores my filter even after I have clicked "Set Filter" (that is another problem...).