I've created an index as a geometry look up table, containing the geojson for UK postcode districts (~3000 entires)
I now want to overlay data from a raw data file (various text and values for each district but no geometry, ~1million entries), by joining to the geometry index using the text of the district name in both indexes.
I can get something on screen with a terms aggregation join i.e using the geometry index as the layer (left source) then and binding the raw data (right source) in the terms aggregation.
However, none of the right source data is visible on the map in the tooltips nor is any of the raw data filterable. (I was hoping to use the Controls widget to make it filterable).
Is what I'm trying to do possible with Maps, and if not, is there a clever workaround?
From the right you can only get aggregated metrics, counts, sums, averages, etc. This is a simple example (on 7.7) joining a countries and populated places datasets based on the country identifier.
On the other hand later you cannot filter in a dashboard based on the right index properties, like willing to filter the aggregations in the countries for cities with a minimum population. @Nathan_Reese can you please confirm if I am correct?
Following my example, the filter for the populated_places index from the Controls visualization ends up in the countries index, but I may be doing something wrong.
oooh thanks!!, now I finally get it, following my example now I can filter the right side of the join and change the result of the aggregation, I only had to disable that first switch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.
