I have a requirement to perform reconciliation / join between 2 indexes.
Person A ( index A ) has Cars AAA, BBB, CCC, DDD
Person B ( index B ) has Cars BBB, EEE
We wanted to build a widget ( pie chart / table ) in real time without pre computing to see below results:
- Person A - Total Cars ( 4 ), Have same cars of Person B ( 1- BBB ), Cars not with Person B ( 3 - AAA, CCC, DDD )
- Person B - Total Cars ( 2 ), Have same cars of Person A ( 1- BBB ), Cars not with Person A ( 1 - EEE )
Please let me know are there any means that Elasticsearch / Kibana supports to build above visualisation in real time without pre computing them.